multiple combo boxes

[oohmygod831]

i have a form which will book in information and i need to make it 'idiot proof' so i decided to use combo boxes so the user can only select the data i let him.

what i need to do is this. My first combo box would list values from a table, the second however would list values probably from a query which would be dependant on the selection from the first combo box.

Is this possible within a single form?

i have tried [Forms]![yourformname]![comboname] in the query that the second combo box would access but it wouldnt work.

 

[ColinEssex]

Search for 'cascading ComboBoxes' - this question occurs weekly here.

Col

 

[missinglinq]

As Col suggested, there's beacoup references out there for Cascading Comboboxes. Here's a how-to from the bytes.com:

http://bytes.com/forum/thread605958.html

 

[oohmygod831]

Just followed the tutorial in your link and it worked a treat, Cheers missinglinq

 

[missinglinq]

Glad it helped!