Sub Forms

[Garry]

I have a subform based on a query that shows a list of “OPEN†items. The
subform view is continuous forms. I have added a combo box to select a new
status for each “OPEN†item. Subform looks great, combo box works as
desired, BUT if I select a new status for one of the records, every combo box
changes. (Actually, after some tests, it appears that any unbound control in
the sub form acts the same way – as if there is only one field for all
records in the recordset). I would like to be able to see all Open records
(reason for continuous forms) and be able to select a new status for each
item independently. Can this be done?

Thanks – Garry Gross

 

[Ofer]

If a field is unbound, when you select a value, it will automatically dispay
it in all the records, as you already noticed.
you should bound the combo to a field in the table, so you can save your
selection per record, unbound combo wont save the selection in the record.

So
Create a field in the table, if you didn't already do that, to save the status
Check if the field apear in the recordsource of the form
Bound the combo to the field
Now the value selected will be saved and displayed seperatly for each column