By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,204 Members | 1,161 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,204 IT Pros & Developers. It's quick & easy.

Read only version of a form.

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.