Replace a value from field A to field B (table) through a form

[SheilaAlighieri]

Hi,

I placed a similar message before in another part of the forum. But I think my previous idea was wrong, so here I try again I am using Access Y2K, but in the office they have Access 97. If anyone can present me a solution which work onboth, that would be super!

I would like to transfer a value from field "A" to field "B" by use of a text box. In other words, the value that is entered in the textbox should be replaced from "A" to "B". Ofcourse the action has to relate to one specific record. Therefore I would like to add some criteria's to the action: "Name" and "Project Number".

So for instance:

Name: "X"
Project Number: "2"
Value to transfer from "A" to "B": 100

Should do the following:
For the records relating to Name X with Project Number 2 a value corresponding to 100 should be replaced from "A" to "B".

I hope my explantion is clear like this If anyone could help me out a bit, that would be great. This is the last problem for me to solve before I can completely finish my database.

Sheila