>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.
>
Include the KeyId field from the customer table in your SQL but do not display that column. Use that as the bound column.
Mark McCasland
Midlothian, TX USA