Auto fill-in fields

[Guest]

Can I get Access to automatically "fill-in" fields if I use a combo box

I have a on a field label "last name". I would like Access to fill in the first name
Can anyone Help!!!!

 

[Arvin Meyer]

Include all the fields you want to use in the combo box's row source. They
do not need to be visible. Then refer to the column number (zero based) in
the AfterUpdate event of the combo, something like (aircode):

Sub cboMyCombo_AfterUpdate()
Me.txtFirstName = Me.cboMyCombo.Column(2)
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access