Delete of Record Navigation disabled in continuous form of ADP

  • Thread starter Thread starter Simon Niederberger
  • Start date Start date
S

Simon Niederberger

Hi

I have an ADP (Access 2002, using Access 2000 format) w/ SQL Server. In a
simple continuous form with a table "Teams" as record source, the delete
button is disabled in the record navigation. Settings are:

Form
Allow deletions: Yes
Allow edits: Yes
Show Record selector: Yes

Table Teams:
ID: primary key, Increment
Description: varchar(100)
(No foreign keys to or from table)

If I open the table directly in Access, delete works. But in the form (but
continuous form and datasheet), delete is disabled. What do I have to check?

Thanks
Simon
 
Simon Niederberger said:
Hi

I have an ADP (Access 2002, using Access 2000 format) w/ SQL Server. In a
simple continuous form with a table "Teams" as record source, the delete
button is disabled in the record navigation. Settings are:

Form
Allow deletions: Yes
Allow edits: Yes
Show Record selector: Yes

Table Teams:
ID: primary key, Increment
Description: varchar(100)
(No foreign keys to or from table)

If I open the table directly in Access, delete works. But in the form (but
continuous form and datasheet), delete is disabled. What do I have to check?

Thanks
Simon
Click to expand...

There isn't a delete button in the record navigation buttons. The red
button with a white cross in it is a cancel query button, not a delete
button.

It's only enabled when the query populating your form, datasheet or whatever
is still running. Clicking it will stop the query, it will not delete
anything.
 
Back
Top