Update Underlying Table

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

Guest

I have a form that just displays information about an underlying table. The
Edit/Add/Delete records properties are all set to NO because I don't want
users changing the information shown on the form. I do, however, have a
button on the form that I want to change the underlying table data. Is the
best way to do this with some sort of SQL Update statement in the Click event
for the button? Just looking for a nudge in the right direction.

Thanks.
 
I take a slightly different tack & have an option button on the toolbar of
the form and a Private subroutine which toggles the Locked property of the
controls. When the form is opened the controls are set to Locked. This way a
user cannot accidently type in the autoselected field - usually I do this
with inexperienced users.

The user can click the option button to unlock the controls and make any
changes required.

In the OnCurrent or AfterUpdate event the TogLock subroutine is called to
reset the lock.
Hope this helps
Terry
 
Back
Top