Drop Down boxes

[Patrick_q]

I have a database that I am trying to create a form in. In the form I have a row of drop down boxes. What I want to happen is when a value in the first drop box is selected the values in the second drop box change so the user is able to select a value in it.

Basically I want to be able to change the values contained in the drop box according to what the user selects in another drop box.

If anyone can help with this it is greatly appreciated.

 

[Abby N]

This can get a little complicated, depending on exactly what you're trying to do. However, if you base the second and subsequent list boxes on queries with criteria based on the first field, that usually does the trick. If you go this route you should also code the first fields 'After Update' event to requery the other fields. This will ensure those fields have the most recent data. Good luck.

~Abby