Access 2000 - DLookup question

  • Thread starter Thread starter Charlie
  • Start date Start date
C

Charlie

I have 2 combo boxes that are related. How can I populate
one box and have the other box automatically populate?
 
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
 
Back
Top