Revised field on a Form

[captainlove]

I have a datasheetform that takes it value off a query. In my datasheet form there is textbox that has a value (unit cost),that it take off the query that feed the form.

Then I have an unbound textbox(Revised cost) whose control source is unit cost. So I have two textboxes with the same value. What I want to do however is that everytime I enter a value into the revised textbox. I want this value to show up and to be stored as the value for that textbox until such a time when I decide to change this value again for a specific item.

Can anyone help with this

 

[georgedwilkinson]

It is considered bad protocol to post the same message twice.