Duplicate Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that gets populated from a table. Nothing new. I would like to
have a button on that form that copies the current info to an identical form
so it can be modified separately. The purpose is the original form is locked
to a non-logged in user, but I would like to give the opportunity for them to
change a particular record and then flag it for a supervisor to use. The
supervisor the decides if the permanent record is updated.
Any ideas?
Thanks in advanced
 
try this:

add the following fields to your table:

RecordID_edit, long integer

when the non approved user wants to change a record, make a
copy of it and fill RecordID_edit with the RecordID it is
changing

on the supervisor's form, have an option to filter on
records where nz(RecordID_edit,0) <> 0

if the "changed" record is not approved, it can be deleted

if it is approved, the original record can be deleted.

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 
Back
Top