I am having problems with setting up a set of combo boxes.

What I am trying to do is if combo Productline is empty then in combo PartNumber would show all products but if combo Productline has a value selected then in the combo partnumber would only be able to select the partnumbers in that productline.

Mike,

Do a search on "Cascading Comboboxes" here. There should be plenty
of samples.

Wayne

I actually have already looked for it in the cascading combos with no luck all the ones that I have found requires data to be entered in order to go to the next combo.

Ok I finally figured out what to do

For others in the query you would enter something like this:

field:
[Category]=[forms]![frmIssue]![comboCategory] Or [forms]![frmIssue]![comboCategory] Is Null

Criteria:
true

Ok I finally figured out what to do

For others in the query you would enter something like this:

field:
[Category]=[forms]![frmIssue]![comboCategory] Or [forms]![frmIssue]![comboCategory] Is Null

Criteria:
true

And add

Show:
uncheck


http://www.access-programmers.co.uk/forums/showthread.php?t=103312

^