Combo Box Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Table called "Manuf".

I have a form called "ProductCompareForm.

I have 2 combo boxes called "ComboManuf1" and "ComboManuf2".

When I click a button on the form called "CommandDev1" I need "ComboManuf1"
to be populated by a specific record (the 2nd one-"Alpha") from the "Manuf"
table and "ComboManuf2" to be populated by a specific record (the 4th
one-"Greenleaf") from the "Manuf" table.

I would just do an on click ComboManuf1 = "Alpha", ComboManuf2 =
"Greenleaf", but there are cascading combo boxes based on these two.

I've already looked and looked at past "cascading combo boxes" posts and
can't find the answer anywhere.

Can someone tell me what the code is for this? I've tried to figure it out
and just don't yet have the skills.

Thank you in advance for your help.
g
 
Gee,

On the Enter event of the comboboxes that are dependent on the values in
ComboManuf1 and ComboManuf2, put code the equivalent of...
Me.NameOfCascadingCombo.Requery
 
Back
Top