Data entry property=yes keeps switching to no. Why?


R

rockwiler

I have several forms that I want always to open in data entry mode. I
have the Data Entry property set to 'yes', but it keeps on reverting to
'no'. Nobody is getting into the designs, so I am at a loss as to why
this is occurring. it does not happen every time the form is opened,
but every few days i will find one or another of them has reverted to
'no'. Any ideas?
 
Ad

Advertisements

K

Ken Snell \(MVP\)

Does the form's programming manipulate the setting of that property? If yes,
it's possible someone is closing the form while it's set to Yes. Or it's
possible that your code closes the form and tells it to save the settings.

You can always ensure that your form is opened in DataEntry mode = Yes if
you open it from another form and use the acFormAdd value for the fifth
argument of the DoCmd.OpenForm method. This overrides whatever setting is in
the form's design view.
 
Ad

Advertisements

D

Dirk Goldgar

rockwiler said:
I have several forms that I want always to open in data entry mode. I
have the Data Entry property set to 'yes', but it keeps on reverting
to 'no'. Nobody is getting into the designs, so I am at a loss as to
why this is occurring. it does not happen every time the form is
opened, but every few days i will find one or another of them has
reverted to 'no'. Any ideas?
I don't have any ideas different from Ken's as to why it's happening.
If you can't solve it, though, here's a workaround: base the form on a
query that explicitly returns no records. For example, if you have a
form that is currently based on TableX, change its RecordSource property
to the SQL statement

SELECT * FROM TableX WHERE False;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top