Autopopulate fields

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
 
L

Lynn Trapp

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
 
Top