View Full Version : Lock fields on all but new records


ctaylor
03-21-2001, 07:59 AM
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
03-21-2001, 01:30 PM
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.