How to create auto populated data drawn from a table with multiple attributes

K

Ken Rhoads

How do I get multiple table attributes from my "USER ID"
table to display on my form when the form combo box is
only bound to one column and that column is the key on
the table? I want to be able to have the user enter a
system user id and have that pull the user's first name,
last name, phone number, etc... from the USER ID table
and autopopulate that data in other text boxes on the
form. The USER ID itself would be stored in the record
but the other information tied to the USER ID table would
only be displayed. Can anyone help me with this. Thanks.
 

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

Data entry for a table from a form 1
Adding records to table from a form, with pre-populated values 5
How to set different combo box values for new record? 6
Data Entry VBA 4
VBA - retrieve data on last create named range from previous inserted named range 0
combo box showing a field or a table list 4
Auto Populate a Field 1
Access Automatically Send a notification email once a record is added 0

Top