Changing a cell content in Access97

[Shella]

Hi
When a form is in Datasheet view, each row represents a record and
each column represents a field of the record. The problem is if I change
the content of a field for a row (record), then the field of all rows
(all records) will be changed as well, the code is

Me![ProductNameCombo] = Me![ProductNameCombo].ItemData(0)

I change the content of [ProductNameCombo] of the current row
(current record) by using the codes listed above, but it's not only the
ProductNameCombo of CURRENT row to be changed, but ALL rows will
be changed as well, how can I change a field of the current row without
affecting the other rows ? Thanx in advance.

[tarandhingra]

If u can send me the zip file of ur source code then i'll b able 2 give u some solution.

u can send me at [email protected]