If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Error: Record is Deleted
Hello,
I display records on the form. Then I delete one of the records directly from the table. Then I want the form to redisplay the records except the one that is deleted. However, I click on the form after the delete event I get the error saying that the "Record is Deleted" and the fields of that record are filled with "#Deleted". I tried to refresh, repaint and requery and nothing worked. I also, run a process on the same form where I append a record to the table and the requery works fine. The new records appear on the form right away. However, when I delete the records they are filled with the "#Deleted". How to refresh the form to reflect the deletion of the record after delete statement was run: db.execute( "delete * from table1 where field1 = "blah") me.requery --doesn't work me.refresh --doesn't work Any help is greatly appreciated, Lester |
#2
|
|||
|
|||
Error: Record is Deleted
Lester:
Please do not post your questions in multiple groups. I'm sure you feel your question is very important, but you do not need several people working on it. Rick B "Lester" wrote in message ... Hello, I display records on the form. Then I delete one of the records directly from the table. Then I want the form to redisplay the records except the one that is deleted. However, I click on the form after the delete event I get the error saying that the "Record is Deleted" and the fields of that record are filled with "#Deleted". I tried to refresh, repaint and requery and nothing worked. I also, run a process on the same form where I append a record to the table and the requery works fine. The new records appear on the form right away. However, when I delete the records they are filled with the "#Deleted". How to refresh the form to reflect the deletion of the record after delete statement was run: db.execute( "delete * from table1 where field1 = "blah") me.requery --doesn't work me.refresh --doesn't work Any help is greatly appreciated, Lester |
Thread Tools | |
Display Modes | |
|
|