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

  • Thread starter Thread starter rockwiler
  • Start date Start date
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?
 
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.
 
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;
 
Back
Top