Read-only form, Load event.

[david epsom dot com dot au]

I have an unbound form that may be 'read-only' or 'edit'.

DoCmd.OpenForm strForm$, , , , acFormReadOnly , acWindowNormal, strOpenArg

When I open the form using the 'read-only' setting (acFormReadOnly), the
'Load' event does not fire until I close the form. If the form is bound to a
table, there is the same problem if the table is empty.

This is unexpected: is it normal?

(david)

 

[Dirk Goldgar]

I have an unbound form that may be 'read-only' or 'edit'.

DoCmd.OpenForm strForm$, , , , acFormReadOnly , acWindowNormal,
strOpenArg

When I open the form using the 'read-only' setting (acFormReadOnly),
the 'Load' event does not fire until I close the form. If the form is
bound to a table, there is the same problem if the table is empty.

This is unexpected: is it normal?

(david)

I can't reproduce it (A2K2). Your description seems clear, but can you
give a detailed scenario? What version of Access?

 

[david epsom dot com dot au]

All my testing had been done in one database, with test cases
derived from one form (A97 and A2K on two PC's) . I just tried it
with a new database and a new form, and I'm back on track again.

thanks

(david)

 

[david epsom dot com dot au]

On re-testing:

The problem is only when the form is bound to an empty table.
A97 and A2K, not tested with other versions. There is no problem
with an unbound form (unless you bind it in the 'open' event).

I guess I'll have to move the 'table filling' code out of the
'load' event and into the 'open' event if I want to have a
read-only version of the form.



(david)