Delete of Record Navigation disabled in continuous form of ADP

[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

 

[Baz]

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

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.

 

[Simon Niederberger]

Now I feel kinda stupid, but anyway, thanks for the explanation ;-)

Simon

 

[Baz]

Now I feel kinda stupid, but anyway, thanks for the explanation ;-)

Simon

Believe me, you're not the first... ;-)