How to make the address appear after I selecet a name in a new ent

E

eduardovieira

Hello Access Users, this is my first post.
What I would like to do is when entering a new record, after I select a
customer name, from a dropdown list, that it's corresponding address would
automatically show. How should I design this:
Suppose the table fields for the form are these:
Customer
Address
Item_borrowed

And a table for lookups would have these fields:
Customer
Address
 
A

Arvin Meyer [MVP]

If you add the address column to the combo box, and set its column width to
0, you can refer to it as the controlsource of a textbox, or feed the value
to a bound textbox:

Sub MyCombo_AfterUpdate()
Me.txtAddress = Me.MyCombo.Column(2)
End Sub

Column(2) is the third column.
 
Top