Combo box query based on combo box

[brian7268]

I have a form that the user first selects the Town and then selects the street. I would only like the Street combo box to be based on the Town combo box selection.

For example, if the user selects Boston, I ONLY want the Boston streets to be available for selection in the Street combo box.

My backend database has a table Streets that has 2 columns: the name of the street and the town.

I know this is a common thing in forms and I apologize if this is a repeat question, but I could not find a clear answer anywhere else.

Thanks!!

 

[pbaldy]

Try:

http://www.baldyweb.com/CascadingCombo.htm

 

[brian7268]

Perfect.

Exactly what I was looking for - thanks!!

 

[pbaldy]

Happy to help!