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