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