How to use AutoLookup when adding or changing values?

C

CraftHer

I have an entry form that saves information to customer table. One of the
fields in the customer table is Preference. The valid values for Preference
are stored in tblPreference. When I choose a Preference for a customer, I am
storing the Preference ID from the tblPreference.

When I enter or change a Preference ID for a customer, I want the Preference
description from tblPreference to show in a text box on the form. I will not
be using this text box to add/change preferences, only to view.

Please explain to me, with as much detail as possible, how do I have the
description field automatically populated when the preference field is added
or changed?
 

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

Table Preferred width is changed when pasting 1
Auto populate value from one task to another in MS PROJECT 0
Copy previous record into form field 0
Update back-end tables, fields, relationships etc... 6
Persistent variable? 2
Windows Image Acquisition 0
CUSTOMIZING SUBFORMS 0
How do I allow or disallow editing 1

Top