Select allOpen in new window
DELETE FROM tblaccounting2;
Also, the table shows #delete# in all the fields if I open the table, but if I refresh the table, the same record appears again.
That sounds as the table isn't linked properly.
Delete the linked table and recreate the link ensuring that a primary key is selected.
I don't know however, what was wrong with that table.
I hope it does not happen again.
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent