Lock fields on all but new records (1 Viewer)

ctaylor

Registered User.
Local time
Today, 11:48
Joined
Feb 13, 2001
Messages
18
I have a database where selection of a sales order number autocompletes several fields on a form, then sets those text boxes ENABLE value to FALSE.

My question is HOW CAN I SET THE ENABLE PROPERTY TO TRUE ON RECORD CHANGE?

What is the event name associated with record change?
 

llkhoutx

Registered User.
Local time
Today, 05:48
Joined
Feb 26, 2001
Messages
4,018
I generally keep continuous forms locked to avoid inadvertent data modification by users. If a user wants to modify a row, I have them double click a specific field on the row to enable to editing. When OnCurrent fires I have moved to a different record and immediately disable all rows.
 

Users who are viewing this thread

Top Bottom