Read only version of a form.

[tdmailbox]

I have an access form that has VB code to enable and disable individual
fields depending on the state of other fields. That works great.

However, now I am looking to create a read only version of these forms
so that managers can review data entered without messing it up. Is it
possible to call these forms as read only? My concern is I am not sure
if it is possible to call the forms as read only without having the
sections of VB code that selectivly enables fields override the fact
that this person is read only.

Is that possible? If so how would I call the form? Currenly I lock
fields on a field level so I am not sure how to do it on a form level.

[Wayne Morgan]

If you use the AllowEdits, AllowAdditions, and AllowDeletions properties of
the form (set them to No/False) you can set the form to "read only"
regardless of what you do to the controls individually. Another option would
be to set the RecordSet property of the form to Snapshot instead of Dynaset.

--
Wayne Morgan
MS Access MVP
<td*******@yahoo.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

I have an access form that has VB code to enable and disable individual
fields depending on the state of other fields. That works great.

However, now I am looking to create a read only version of these forms
so that managers can review data entered without messing it up. Is it
possible to call these forms as read only? My concern is I am not sure
if it is possible to call the forms as read only without having the
sections of VB code that selectivly enables fields override the fact
that this person is read only.

Is that possible? If so how would I call the form? Currenly I lock
fields on a field level so I am not sure how to do it on a form level.

[Bas Cost Budde]

You can set the AllowEdits, AllowAdditions and AllowDeletions all to False

td*******@yahoo.com wrote:

I have an access form that has VB code to enable and disable individual
fields depending on the state of other fields. That works great.

However, now I am looking to create a read only version of these forms
so that managers can review data entered without messing it up. Is it
possible to call these forms as read only? My concern is I am not sure
if it is possible to call the forms as read only without having the
sections of VB code that selectivly enables fields override the fact
that this person is read only.

Is that possible? If so how would I call the form? Currenly I lock
fields on a field level so I am not sure how to do it on a form level.

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
For human replies, replace the queue with a tea