List boxes in forms

[Andrew Pla]

HI hope you can help me!

I'm wanting to create drop down lists that are filtered as a result of a previous field, but not having much luck!

I've tried using a query to do this, but not having any luck! am i going down the right path?

Do i need a new query for each list, or can they all run off one query?

How can i refresh the list if a previous field is updated?

Additionally where there is only 1 option (similar to a lookup in excel) how can i set this without using a list box?

Hope that in the xmas spirit, my job is safe!!

Merry xmas to all.
Andrew - Hull

 

[Peter Reid]

See the following link for a good explaination

http://www.mvps.org/access/forms/frm0028.htm

 

[neileg]

You can search in these forums for Cascading Combo boxes.