Full Version: Cascading comboboxes in subform
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
dhouston
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
and
http://www.utteraccess.com/forums/access/access1011343.html

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.
JohnLVMVP
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]
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.