Access 2000 - DLookup question

[Charlie]

I have 2 combo boxes that are related. How can I populate
one box and have the other box automatically populate?

 

[Allen Browne]

See:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm

 

[AlCamp]

Charlie,
Let's use an example of cboCarMake and cboCarModel. cboCarMake would
allow user to pick a CarMake (Ford, Toyota, Dodge, etc..). In the query for
cboCarModel use the contents of cboCarMake to filter the possible choices in
cboCarModel. Filter the CarMake column of cboCarModel with a criteria of...
=Forms!frmYourFormName!cboCarMake
This way, if "Ford" was selected in cboCarMake, only models that belong to
Ford will be displayed in cboCarModel.
hth
Al Camp