OpenForm Action: Data Mode

[Mike S.]

I have a Form in my Database that can be opened in two
different macros.

In one macro the form is set to open as "Read Only".
In the other macro the form is set as "Edit".

But with the one separate macro set to "Read Only", the
other macro opens the forms as "Read Only" also.

How do I get around one macro's settings from affecting
the other macro's settings?

 

[Van T. Dinh]

1. If you meant you use the "Read-Only" Macro to open the Form and then
(*without closing the Form*), use the second "Edit" Macro, then it is likely
that the OpenForm action will be ignore since the Form is *already* open.

2. If you meant the Form is closed and then you use the "Edit" Macro to
open the Form and the Form is still "Read-Only", then there may be a few
different reasons:

* The RecordSource of the Form is NOT updateable. This can happen if the
RecordSource is a Query based on 2 or more Tables.

* The RecordsetType of the Form is set to "Snapshot".

* The Form's AllowEdits Property is set to False.