Read only problem?

[PARSO]

i have a form, which consists of a tab control, in each page of the tab is a different subform. there is also a drop down list which allows users to select the record they want to view, i could lock the records yes, but i also want the same form to be available as a writeable from.
on my switchboard i have 2 buttons "read only form" and "Edit form"
my login system denies access to the edit form if users only have little access, so how do i make the read only form, while stil enabling the drop down, but disabling the fields for editing??

thanxs in advance

 

[ghudson]

You can't but you have options.

You can set the "Allow" properties in the forms OnOpen event based on who is logged into the db...

Me.AllowAdditions = False
Me.AllowDeletions = False
Me.AllowEdits = False

You can lock each field and button that you do not want the user to alter or use.

If you were using Access you could set up a user workgroup and not grant those users the add/delete/edit options for each table.