Read Only Form

[Guest]

Hi

I would like to have a form that is for viewing purposes only, read only
effectively.

I thought by setting the form properties Allow Edits, Allow Deletions and
Allow Additions to 'No' this would do the trick. But it still allows me to
alter data.

Any ideas?
Thanks

 

[ifcgroup]

As long as you have read/write access to the table/query behind the
form... you will be able to change data. Also, you could try opening
the form as ReadOnly instead of changing the form properties.

 

[Ron2006]

As long as you have read/write access to the table/query behind the
form... you will be able to change data. Also, you could try opening
the form as ReadOnly instead of changing the form properties.

The last suggestion is probably the best, but I don't believe the
default standard switchboard will handle that ( I don't use it if I
can help it).

If worst comes to worst, select all of the fields on the form and
change the Locked property to Yes.

Ron

 

[ifcgroup]

for the standard switchboard to open up a form as read only... create
a module (doesn't matter what you name it) and then inside create a
function such as:

Sub OpenFormReadOnly()
DoCmd.OpenForm "FormName", acNormal, , , acFormReadOnly
End Sub

Then on the switchboard manager, Command: Run Code Function
Name: OpenFormReadOnly