Help With getting values using Combo Box

[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

 

[Pieter Wijnen]

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