Query using Multiple Combo boxes

[Hinfer]

Hi,

How do I build a form that queries using multiple combo boxes? I am trying to create a form that functions like MS Excel Advanced Filter function. That is, I have a table with the fields: Country, State/Province, City, Location. I want the user to pick the Country in the first combo box and the 2nd combo box will only contain State/Provices specified by the first combo box (country). The 3rd combo box will display of cities within the specified state/province and country. The last combo box will define the exact record (Location). I have other fields in the form that I want to autopopulate when the user picks the last combo box(Location). Again for my purpose, Location will define a unique record.

Can anyone give me any direction? If this has been posted here before, can someone point me to the right direction? I have found threads that dealth with one combo box but not multiple ones.

Thanks

 

[BoxHead]

Check the Microsoft Knowledge Base at

http://support.microsoft.com/directory/default.asp

Threads Q98660 and Q97624 should get you going.


HTH


John

Use what you have,
Learn what you can,
Create what you need.

 

[Lee24]

I HAVE JUST COMPLETED SOMEHING SIMILAR IF YOU WISH THE CODE PLEASE LET ME KNOW!


LC

 

[Hinfer]

Lee24 - Thanks I have just completed it but I would very much like to know how you did it. I can also show you how I(with the help of an Tek-Tips expert user - thanks PaulF) did it. Check out thread181-169588