Hello,
I have a combo box set up as follows:
Do While Not rt.EOF
Combo14.AddItem rt!LastName & ", " & rt!FirstName
Text58 = rt!FirstName
Text59 = rt!Surname
rt.MoveNext
Loop
When the user clicks on the combo box above, the text boxes on that same page must also show the LastName in text1 and Firstname in text2 (separately). Basically I would like to fill in for the unknown’s below (it is a separate command on the same form):
daoDB36.openrecordset (Select Address, LastName, FirstName From Contact where contactLastName = unknown1 and contact.FirstName = unknown2)
-Unknown1 – Should show rt!LastName only from Combo14 above (in Text1)
-Unknown2 – Should show rt!FirstName only from Combo14 above (in Text2)
Thank You
I have a combo box set up as follows:
Do While Not rt.EOF
Combo14.AddItem rt!LastName & ", " & rt!FirstName
Text58 = rt!FirstName
Text59 = rt!Surname
rt.MoveNext
Loop
When the user clicks on the combo box above, the text boxes on that same page must also show the LastName in text1 and Firstname in text2 (separately). Basically I would like to fill in for the unknown’s below (it is a separate command on the same form):
daoDB36.openrecordset (Select Address, LastName, FirstName From Contact where contactLastName = unknown1 and contact.FirstName = unknown2)
-Unknown1 – Should show rt!LastName only from Combo14 above (in Text1)
-Unknown2 – Should show rt!FirstName only from Combo14 above (in Text2)
Thank You