Column numbering starts with zero. So column 3 to the combo is actually
column 4, which means nothing. Also, what is your PK? try putting your PK in
column zero and just setting the column width of it to 0" and make it the
bound column.
--
Milton Purdy
ACCESS
State of Arkansas


"KAquestions" wrote:

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


.