how do I save entries from one field into another field in an acc.

[Guest]

When I enter a plate # into one field, I need that number to be recorded into
another field, and saved. That way all of the previous plate #'s are saved,
and I can change the operational plate #. Any ideas?

 

[John Vinson]

On Wed, 17 Nov 2004 06:23:02 -0800, Mike d <Mike

When I enter a plate # into one field, I need that number to be recorded into
another field, and saved. That way all of the previous plate #'s are saved,
and I can change the operational plate #. Any ideas?

If you have multiple historical plate numbers, you will need another
*table*, not just another field. Could you explain the structure of
your tables? How are you entering the data - in a Form, a table
datasheet, or what?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guest]

When I enter a plate # into one field, I need that number to be recorded into
another field, and saved. That way all of the previous plate #'s are saved,
and I can change the operational plate #. Any ideas?

I have a table that has all of my criteria in it. ie. Name address, plate
#, and previous plate #'s. I set up a form to record the information easily,
and I have a report that displays all of the entered information.
What I would like to happen is every time I enter a plate number into the
plate# field, I want that plate number to appear in the previous plate #
field. Then when I delete the Plate #, I want that number to stay in the
previous plate # field. That way I can have a "History" of the plate
numbers, and the current plate number used.