[AccessD] User Form Snapshot

Hollis, Virginia hollisvj at pgdp.usec.com
Fri Feb 9 08:04:00 CST 2007


I am trying to create a function that will open the form for users only.
I thought I would use the same form as the Data Entry users instead of
creating a separate form. They can't update or edit the record, just
view. How do you set the controls on the form to locked?  Or set it to
snapshot?

 

The below function does not work, it does not open it ReadOnly, they can
still change the data.

 

Function OpenUserForm()

    

        DoCmd.OpenForm "frm_InventoryMain", acNormal, , ,
acFormReadOnly, acWindowNormal

        Forms!frm_InventoryMain.cmdAddNew.Visible = False

    

End Function

 

Virginia




More information about the AccessD mailing list