Help!! Combo box

[yb]

I have a unbound combo box that displays PartName, Location and
Serial#. Control source for the Location(unboun d) is set to
=cboDevice.Colu mn(1)and Serial#(unbound ) is set to =
cboDevice.Colum n(2)

My problem is when I have same PartName appearing multiple times with
different Location and Serial #.The values of the 2 text fields do not
change.

[pietlinden@hotmail.com]

Re: Help!! Combo box

works fine if the unique field value is first (Serial#). If you have
to, cheat and include an extra hidden column (SerialNo). then it works
a champ. Otherwise I get the exact same thing. Probably because since
PartName does not uniquely describe a record, it doesn't need to update.

[Rog]

Re: Help!! Combo box

You don't tell us where your combobox gets its data from. Are
PartName, Location and Serial# fields from a table? If so, does your
table have a primary key? If not, add an autonumber field as the
primary key and use that as the first column in your combobox. You can
make it invisible by setting the column width to 0.

[yb]

Re: Help!! Combo box

Combo box was populated from a table and I used ID as you mentioned as
the first column in the select statement and it worked.

Rog, Thank you for your help!!