Filter available values in a combo box, based on another combo box

[msmithtlh]

I have a subform. On this subform, I am trying to use 2 related combo boxes. The first combo box selects a category. In the second combo box, I want to select items that are a subset of the category.



category = BP field, subcategory = BP error

The table for the category has only the category names (primary key). The table for the secondary items has the category name and the sub-category name. The primary key is the two fields, concatenated.

Relationship is one (category) to many (subcategories).

On the subform, I can select the category. When I go to select the sub-category, I get a prompt to "enter parameter value." The value it is showing is the form name of the category field. If I manually type in the value, everything works fine. I can't figure out what is missing for it to recognize the value in that field.

Even though I'm just creating the database, it is too large to attach. I am attaching a screen shot.screen shot.doc

Thanks in advance.

[ItsMe]

So it is not recognizing

Forms!BP Error List!BP Field

The subform seems to be looking for a control name based on VBA. Change that VBA to

Forms![BP Error List]![BP Field]

The spaces in your form and control names can cause issues that often times are resolved by enclosing the names in brackets.

Double check that the control name exists and that it is bound to something via the controlsource issued to the subform by the combobox.

I posted a sample db that has examples of using recordsources via SQL in VBA. The VBA is copy and paste friendly. All of the table/query and field names are displayed and enclosed in brackets.

https://www.accessforums.net/sample-...tml#post191005


.