Using COMBO Box to Query a second combo box.

[imwalrus38]

Hi I am a new user. I'm sure this is simple but I just can't get it. I want to use a dropdown box with letters A-Z to return records in a second drop down box that begin with the lettered selected in the first dropdown box.

Any help would be appreciated.

Thanks

 

[jdraw]

Hi I am a new user. I'm sure this is simple but I just can't get it. I want to use a dropdown box with letters A-Z to return records in a second drop down box that begin with the lettered selected in the first dropdown box.

Any help would be appreciated.

Thanks

This may be helpful:

http://en.allexperts.com/q/Using-MS-Access-1440/cascading-combo-boxes.htm

 

[imwalrus38]

Still need help

The article was helpful in that it showed me how to use cascading combo boxes. I need to know how to write the statement that makes the second box only return items that begime with the letter selected in the first combo box. Any help is appreciated.

Thanks

John

 

[gemma-the-husky]

use a second query with a parameter testing whatever field you need

like forms!myform!mycombobox & "*"

{note that this syntax may be slightly off}

------
after you pick the first cbobox, you then need cbobox2.requery to get the second box to populate properly

 

[imwalrus38]

Thanks

That did it. Thank for your help