If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combo box finding wrong record
Hi all,
This is driving me nutty! And i know it's probably something really obvious that i am just not seeing..... I have a form which has a combo box on it. The combo box has 3 columns, First Name, Surname, ClientID (SELECT qryClientDetails.FirstName, qryClientDetails.SurName, qryClientDetails.ClientID FROM qryClientDetails ORDER BY qryClientDetails.FirstName When the bound column is 1, it works, but only up to a point. If there are two clients called Robert (Robert A and Robert B) and i want Robert B, when i click on him it always displays the data for Robert A. When the bound column is 3, it always shows the last record in the table, no matter what i have selected. HELP!! TIA, Kirst |
Thread Tools | |
Display Modes | |
|
|