SAVE MULTIPLE RECORDS AT A TIME

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

Guest

hi,

How do you prevent the user to accidential change the information while they
viewing the database. User has full access to the database.
My database has multiple subform. the change should be only allowed after a
number of confirmation for each subform or on a click on the save data button
on the mainform
 
One idea would be to set the form's AllowEdits property to No, so by
default the user cannot make changes... then add a command button on the
form to allow edits, with code like:
Me.AllowEdits = True
Me.CommandButtonName.Enabled = False

and another two lines of code in the form's Current event:
Me.AllowEdits = False
Me.CommandButtonName.Enabled = True

so the form goes back to its original state when the user moves to the
next or previous record.

HTH,
Nikos
 
Back
Top