Display Total in a Textbox

[Ali Xihuny]

I'm trying to display total in a textbox using the values from a table.

I have two tables, one with "Room Type" & Different meal rates for that particular room type.

I have created a from in which I can select a room type (using a combo box) and select the meal types I want (using check boxes). I also have a textbox to enter no. of people. Now I want to display the total in another textbox when certain room type and meal type is selected.

For example,

Room1 's Meal_Type1 = $50 & Meal_Type2 = $30

If I select Room1 with Meal_Type2 and no.of people as 2, then the total would be 50 x 2. How can I display this total in the Total textbox?

I also have attached a sample database.

[HansV]

I would calculate the total in a query, and make that query the record source of the form. You shouldn't store the total in a table, since it can be calculated whenever it's needed.

See the attached version:

Sample_Database.zip

[Ali Xihuny]

Thanks Han. The solution was perfect as always. :D