Problem with Combo Boxes in Continuous Forms

[Sameal]

I have a form based on continuous forms. In each of the records in this form is an unbound combobox. The On_Load event of the form is set to fill in these comboboxes. The problem is that as the form moves down to fill the combobox for each record, it changes the values in all the combo boxes on the form rather then the particular combo box for that record. Anyone know how to keep access from assuming that your value is for every combobox and just placing it on the particular record entry?

 

[Aivars]

Move code which updates combobox to OnCurrent.

Aivars

 

[Sameal]

I tried moving the code to On_Current and it still does the same thing. Incidently once everything is opened if I change the value in the combo box for one record it changes the combo for all the records.

 

[LonnieJohnson]

What goes in the combobox? ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[Sameal]

The name of the operation that the current record is on. The combo box is built upon a table of Operations, and the form pulls out the records "OnOp" value to know which operation the item is currently on.