General information
Category:
Coding, syntax & commands
Title:
Full Names in Combo Boxes
I have a combo box populated with the Last Names and First Names of the client's customers. I am using an SQL Select to load them. My problem is probably pretty simple, but has defied me so far: If the user selects the third Smith, let's say, in the list, any attempt I make at finding the proper record in the table fails--I always get the first Smith. The order of the table is LName + FName, but I can't get the combo box to return anything as a Value except LName. The cursor that the SQL Select creates (csrCustomer) is, apparently, not available.
What am I doing stupid??
TIA.
John
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only