cbo keeping the same entries on all records and not changing

[PST]

Hi,
Can anyone help me please?

I have a combo box which displays the primary key. It then takes the other values from the cbo and then displays them in other text boxes in the form.
This is great.

I am trying to keep the values in record 1and then move on to record 2. reecord 2 has the same values as in record 1 (the values from the cbo!!!) I am trying to keep the values in record 1 and then go to record 2 and select different values in record 2 from the same cbo. Record 1 and record 2 as well as any other record contain the same values from the cbo.

I am stuck - I am not sure how to rectify this problem so that I can choose different values. The cbo is based on a query from other tables.

Please let me know how to do this as I am still finding this tiresome.
Many thanks.

 

[Zurvy]

Hey PST,

Could you please be more clear... I really don't understand what you want..

So you have 1 combo-box, containing the primary key, fill is the list boxes on your form.

Now what do you mean by you are trying to keep record 1 and move to record 2? Could you make a snapshot of your form or just be more clear....

 

[Pat Hartman]

If you want to retain a different value for each record, the combo needs to be bound to a column of the RecordSource. Currently it isn't bound. Access keeps only a single set of properties for each control so multiple values are not supported for unbound controls.