Data Access Page DataEntry Property = True

[Guest]

I have a data access page that the DataEntry property is set to true and I'm
getting the following error message when it loads:

"Either BOF or EOF is True, or the current record has been deleted.
Requested operation requires a current record."

If I change the DataEntry property to false, the page works fine. Any
insights? I really need it to open to a blank form.

 

[Ken Snell [MVP]]

Sounds as if the recordset that is the page's data source is not updatable,
therefore no new record can be created by the form.

 

[Guest]

It's connected to an updatable table, but I do have some fields (for display
purposes only) on the page that are from related tables. Any suggestions?

Sounds as if the recordset that is the page's data source is not updatable,
therefore no new record can be created by the form.

 

[Ken Snell [MVP]]

Are you using a query to get the values of those fields from the related
tables? If yes, that may be the source of your problem; data access pages do
not allow you as much flexibility in what is an updatable query as do forms.

But, to give more info, you'll need to post the Recordset here, and post the
Unique Table here.

--

Ken Snell
<MS ACCESS MVP>

It's connected to an updatable table, but I do have some fields (for
display
purposes only) on the page that are from related tables. Any suggestions?