Update Underlying Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Langton - 30 Mar 2005 17:17 GMT

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.

Reply to this Message

Terry - 31 Mar 2005 06:27 GMT

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

> 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
[quoted text clipped - 4 lines]
>
> Thanks.

Reply to this Message