I have a pop-up dialog box that asks for criteria and creates report based on that criteria.
I want to have 2 comboboxes, where the second one will only give choices that depend on what you chose in the first one.
How is this done?
(Example, if you choose a specific client, in the second combo you will only have choices of his invoice numbers, not everyone else's)

This is an Access2000 Knowledge Base article but the code is the same for Access97 if that is what you are using.

http://support.microsoft.com/support/kb/articles/Q209/5/76.ASP?LN=EN-US&SD=gn&FR=0&qry=q209576&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

thank you very much