Auto fill-in fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!!!!
 
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
 
Back
Top