LINKING LIST BOXES IN A DATABASE

[Guest]

I am looking for a way, if there is one, of linking two drop-down list boxes
in a database. The first DDLB would contain main categories and the second
sub-categories. I'm hoping that it is possible that when an item is selected
from the first, only those items within that category are visible in the
second.

Any advise would be most welcome

Contracto

 

[Arvin Meyer [MVP]]

Make a criteria in the rowsource of the second list box read from the first.
In the AfterUpdate event of the first list box, requery the second list box.
I have an example here:

http://www.accessmvp.com/Arvin/Combo.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access