Help With getting values using Combo Box

  • Thread starter Thread starter Praveen Manne
  • Start date Start date
P

Praveen Manne

Hi ,

I have 2 tables
1. SSN, First Name, Last Name (1st table fields)
2. SSN, Order, Amount Paid (2nd table fields)

Now I have a form for the second table which contains a Combo Box for SSN. I
can 'choose' from one of the values of SSN Combo Box.

I have 4 text boxes for First Name, Last Name, Order, Amount Paid.
I will manually enter data into Order and Amount Paid textboxes.

But the problem is :

when I choose a SSN from the Combo box I want first Name and Last Name
textboxes to be filled with values from 1st table where the SSN matches.

Please Help

Thanks
 
Assuming Lastname is the first column of the combo & firstname is the
seccond

Sub Combo1_AfterUpdate()
Me.LastName = Me.Combo1.Column(0)
Me.FirstName = Me.Combo1.Column(1)
End Sub


HTH

Pieter
 
Back
Top