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