Autopopulate fields

  • Thread starter Thread starter DM - NPS
  • Start date Start date
D

DM - NPS

I have an enumeration table that includes 2 fields (each field has unique
values) called Common_Name and Scientific_Name.

In my form, I am using combo boxes that lets the user select a name from
each of the fields listed above.

What I want to do is if the person populates the combo box for Common_Name
it will automatically populate the combo box for Scientific_Name, and if the
person populates the combo box for Scientific_Name it will automatically
populate the Common_Name combo box.

Thanks for the help
 
I have an enumeration table that includes 2 fields (each field has unique
values) called Common_Name and Scientific_Name.

In my form, I am using combo boxes that lets the user select a name from
each of the fields listed above.

What I want to do is if the person populates the combo box for Common_Name
it will automatically populate the combo box for Scientific_Name, and if the
person populates the combo box for Scientific_Name it will automatically
populate the Common_Name combo box.

Thanks for the help
Click to expand...

The way to create cascading combo boxes is to requery the "child"
comobobox on the change event of the "parent" combobox. I've never
tried it going in both directions, but you can give it a shot.

Lynn Trapp
www.ltcomputerdesigns.com
 
Back
Top