Combo Box Control

  • Thread starter Thread starter tess
  • Start date Start date
T

tess

I have a form with 2 combo boxes that I need to update
according to what I pick in a lookup field of my form. I
need to first combo box to filter the list according to
the lookup field value and the second combo box to supply
a specific value according to that same lookup field
value. Both combo boxes are based on queries and are
linked to the underlying table of the main form. Can
anyone help?
 
Tess,
Use the value of the field on your form (ex. name of field on form =
Manufacturer) to "filter" the 2 combo boxes.
Let's say, for example, Manufacturer can contain a value (like "Ford", or
"Chevrolet"..etc.), and your combos will display the appropriate Models and
EngineSizes for that Manufacturer.
In the queries behind both combos, include the table field Manufacturer,
and filter that column with a criteria of...
=Forms!YourFormName!Manufacturer
Now, whatever the value of Manufacturer, both combos will be filtered to
only show records that are associated with that value.
 
-----Original Message-----
Tess,
Use the value of the field on your form (ex. name of field on form =
Manufacturer) to "filter" the 2 combo boxes.
Let's say, for example, Manufacturer can contain a value (like "Ford", or
"Chevrolet"..etc.), and your combos will display the appropriate Models and
EngineSizes for that Manufacturer.
In the queries behind both combos, include the table field Manufacturer,
and filter that column with a criteria of...
=Forms!YourFormName!Manufacturer
Now, whatever the value of Manufacturer, both combos will be filtered to
only show records that are associated with that value.
--
HTH...
Al Campagna
Candia Computer Consulting
Candia, NH




---
Outgoing mail is certified by AVG 6.0 as Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.500 / Virus Database: 298 - Release Date: 7/10/03


.
Thank you for your reply, but I can't seem to get it to
Click to expand...
work. I keep getting only 1 record on both combo boxes
and they are the same for each record on my form no matter
what value in the field I'm filtering on is. I'm trying
to filter on an airport code (i.e. DFW, AEX, AMA, etc).
Each of the queries underlying the combo boxes have this
field also. Do you use the field available within the
query or delete that field and use the table for the main
forms airport code field? I've tried both ways and this
doesn't work either.... Any more suggestions? Am I doing
something wrong?
 
Back
Top