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