Cannot delete records in subforms

K

KCO

We recently upgraded to Access 2007. After the upgrade, we can no longer
delete records in subforms. It appears to allow the delete, without
confirmation message though, but when the form is reopened, the data
"returns". Watching the table, the data is never actually deleted. I can
delete data directly in the table, though. The forms are in Access, the
tables are linked to SQL server tables. Any help would be greatly
appreciated. Thanks.
 
B

banem2

We recently upgraded to Access 2007. After the upgrade, we can no longer
delete records in subforms. It appears to allow the delete, without
confirmation message though, but when the form is reopened, the data
"returns". Watching the table, the data is never actually deleted. I can
delete data directly in the table, though. The forms are in Access, the
tables are linked to SQL server tables. Any help would be greatly
appreciated. Thanks.
Click to expand...

Hi,

Please copy code which deletes record.

Regards,
Branislav Mihaljev
 
K

KCO

Hi,

I simply select a row in a datasheet subform and then press the delete
button on my keyboard or press delete button on the toolbar. it deletes the
row on screen, but when I quit the screen and re-open it, the row is still
there.
By the way the subform's data is not linked to a query but directly to a
table.

Best regards,
Kristine
 
Top