pop-up dialog box with combo boxes

[nata4]

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)

 

[Jack Cowley]

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

 

[nata4]

thank you very much