I have asked this question before, but I guess I am not making myself as non of the responses work. I am attaching a copy of the database to clarify matters.

My problem is when I change the value of a row in datasheet view for a particular control, the whole column (Revised cost) in datasheet view get updated(repeated for the whole column) with that value. The problem is every row has a unique record. So how do I change the value for each particular row without the whole column getting updated with that value.

I have tried adding the unbound control as a field of a table the database it does not make any difference


Here are the steps to view this problem in the database

1) click frmstart

2) click the button summary job cost

3) select a value from project number combo box i.e 87633A

4) click editmaterials cost button

5) Change the value of revised column to any numeric currency value

6) All the data in the column get updated to the value


How do change individual cell or rows for the columns


Can anyone help

Your attachment did not make it. After a Compact and Repair then ZIP your db. It needs to be < 394 KB to post.