Read-only form, Load event.

  • Thread starter Thread starter david epsom dot com dot au
  • Start date Start date
D

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)
 
david epsom dot com dot au said:
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)
Click to expand...

I can't reproduce it (A2K2). Your description seems clear, but can you
give a detailed scenario? What version of Access?
 
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)
 
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)
 
Back
Top