Synchronizing Two Fields on One Form

T

TAWise

I have a table "Companies" that contains CompanyID, CompanyName, Address,
etc. I have a form "Projects" for setting up new projects and this form
needs to include the Company ID and CompanyName fields. If someone is using
the "Projects" Form and selects the CompanyName from a dropdown list, is
there some way to automatically populate the Company ID field that
corresponds to the CompanyName field from the "Companies" table. I have
found a couple of articles on this such as "How to synchronize two combo
boxes on a form" but I am not having any luck with the Event Procedure.
Thanx.
 

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

Similar Threads

Trying to Open subform on click event to current record from main form 2
Data entry for a table from a form 1
Data Entry VBA 4
Split form 0
QBF & Query Malfunction 0
Listbox in continuous subform 4
Data entry for a table from a form 2
Copy previous record into form field 0

Top