Duplicating data in fields

  • Thread starter Thread starter Jim Driscoll
  • Start date Start date
J

Jim Driscoll

When creating a new record, I have 3 fields that I
enter data into that are duplicated in 3 fields later on
in the record.
How do I get the data to enter and tab over the
later fields after I have entered data in the 3 prior
fields?



Thank you,

Jim
 
-----Original Message-----
When creating a new record, I have 3 fields that I
enter data into that are duplicated in 3 fields later on
in the record.
How do I get the data to enter and tab over the
later fields after I have entered data in the 3 prior
fields?



Thank you,

Jim
.
Don't put the duplicate field on the form, then on
Click to expand...
closing event for the form run a query to update the field
using the data from the first 3 fields.
 
Larry's suggestion will work, however I just have to say it, even if you
already know it, Normally having the same data in more than one field of a
record, indicates a bad table design.
 
Back
Top