[AccessD] User Form Snapshot

Hi Virgina,

In the Properties list for the form, go to the Data page.

Near the bottom you'll find a property called Recordset Type.  If you set
that to Snapshot, your form will always be read-only.  This is set to
Dynaset by default.

This property could be changed in code during the form's Open event.

Dan Waters

-----Original Message-----
Subject: [AccessD] User Form Snapshot

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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com