Using form fields as query criteria

[bener]

Hi
I need to limit the population displayed in a combo box to only those records that one of their fields match a field already entered in the current form (but not yet saved to the database).
In a food catering application I have a menu table with dish ID, dish name and dish category. In an order from, the user first selects a category and then selects a specific dish. I would like to populate the dish selection combo with only the dishes having the preselected category.
I didn't find a way to refer to fields of the current form in the query selection criteria. Can this only be done using VBA?
Thanks

[Stingaway]

You can refer to the form in the query criteria. Try using =[Forms]![Form Name]![Field Name] in the criteria of your field...

[bener]

You can refer to the form in the query criteria. Try using =[Forms]![Form Name]![Field Name] in the criteria of your field...

Thanks. I did just that. What happens is that the value of the field seems to be read only once at the first use of the combo. Suppose I entered "1" in the creteria field and then activated the combo - I get a correct list filtered according to this value. However if I then change the value of the field, even after moving to the next record, I still get the list using "1" as selection criteria.
See sample DB enclosed

[alansidman]

You need to clear the combo box. Put a command button on your form that has the combo box. In the on click event for the command button type this:

me.comboboxname.value = " "
me.requery

In the afterupdate event for the combo box type:

me.requery

Alan