May 29 2006, 10:32 PM
I am trying to build a form that will be a menuid and then I want a subform to be able to hold the individual food items. I am wanting the first combo box be the group of food and the second to be limited to the group. I have used http://support.microsoft.com/?kbid=209576
I get them to work in a main form but as soon as I put them in a subform either they don't show any items or it shows all of the items.
May 30 2006, 12:16 AM
You have two problems:
1) If this is a Continuous subform, then the second combo box may go "blank" as you move from row to row. To solve that, you have to include the lookup table and field in the form's Record Source and display it in an overlaid text box on top of the combo.
2) When you make your form a subform, any parameter references must change. For example, if FoodItems is filtered: FoodGroup = [Forms]![FoodItems]![FoodGroup] ..., then when you make this a subform, there no longer is a form called FoodItems. It'll have to change to something like: [Forms]![Menus]![ItemSubform].[Form]![FoodGroup]