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

[Guest]

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

 

[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.

 

[Guest]

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Thank you very very much