I have a form that shows a single record based on a query criteria.
When I click a button it is set to use an append query to copy that
record to a separate table, then deletes the record from the first
table. Both tables have a 'DateTime' field that shows when it was last
updated using the Now function.
What I am trying to do is get the 'DateTime' field updated after the
append query copies it to the new table. I have tried updating the
DateTime in the first table before coping the record, but the new time
doesn't get saved in the first table before the record gets copied.
Is there a way to do this, either by getting the DateTime to save in the
first table before the record gets copied? Or by using code to write a
new DateTime in the second table after it gets copied? The 2nd table is
not in the original query to select the single record, only in the
append query that happens after I click an "OK" button on the form.
Many thanks to whomever can help me with this! even if they just point
me in the direction of what to look for!
Thanks,
Ray