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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top