Combo Box In Continuous Sub Form

[terbs]

Ive have a continuous sub form with several combo boxes on each line.

My problem is that whenever I select a value on one combo box, the combo box on every line updates.

Is there a property or someway around this, or is it just not worth my effort?

 

[David Eagar]

Have you tried placing your combo boxes in the header of the subform?

 

[terbs]

They need to be in the detail.

Each record has a combo box.

 

[David Eagar]

Has the combo box different values for each record?

 

[terbs]

Yes the combo box selected value will be different on each line.

The row source is just a simple query. I need to be able to select different values for the same combo box on each line.

The problem is, whenever I select a value EVERY line updates to what I have just selected.

 

[petehilljnr]

You have to bind the combo box to a data field as David Eagar alluded to.

That's the only way it 'knows' that the current line / record is the field that it is updating.

e.g. 2 tables: Table1 (MyID, MyLookupID) and Table2 (MyLookupID, MyDesc).

If your continuous form is based on Table1 and your combo box is based on Table2 (using MyLookupID as the relation), then your combo box should be bound to MyLookupID.

The same goes if you typed in values for MyLookupID instead of selecting them from Table2 as your rowsource.