Populate a value in a form based on another value

[gmeuli]

I have a form that I use for all customers and I add to that form every time
they have a new visit. This form was created from my customer table. I want
to put in their customer ID number and have Access fill in the information I
have already entered. Currently I have to search for the customer form
manually then enter additional information rather than using the ID number to
pull up the form. Is there a way for Access to populate previously entered
data in a field based on another field in that form?

 

[Arvin Meyer [MVP]]

Yes, except that under database Normalization rules, each value in the
database should refer to the key, not another value. However, if you need to
simply display the information in a form, use unbound textboxes. For
instance, create a combo box to select CustomerID and display the customer
name, then add columns in the combo for that customer's address, etc. Set
the column width of all columns except the customer name to zero (0"). Combo
box column indices are zero based - Column 1 is Column(0) so you'd set your
unbound textbox control source to:

=cboCustomerID.Column(2)

for the 3rd column, etc. For reports, use a query to join the data on
CustomerID.