Data Input

  • Thread starter Thread starter Jaye
  • Start date Start date
J

Jaye

How can I ensure that once records have been entered on a
form they are safe and cannot be ammended. Also how can I
set up the form to open ready to enter a new record?

Please help

Regards

Jaye
 
Jaye said:
How can I ensure that once records have been entered on a
form they are safe and cannot be ammended.
Click to expand...

AllowEdits = No
Also how can I
set up the form to open ready to enter a new record?
Click to expand...

DataEntry = Yes

These are both properties of the form found on the "Data" tab of the
property sheet.

A caveat of the first one is that it disallows edits on existing records on
ALL controls (even unbound ones). So if you have any unbound controls
(like a ComboBox for navigating) then these will be locked down as well.
If you don't want that then you will have to use code in the form's Current
event. In that code you would test for the NewRecord property and when
false loop through all bound controls and lock them. When true you would
loop through all bound controls and unlock them.
 
Jaye said:
How can I ensure that once records have been entered on a
form they are safe and cannot be ammended.
Click to expand...

What happens if someone wants to correct a data entry error?

TC
 
Back
Top