deleted record error after delete query

[ck4794]

So I have a form, the record source is select... blah blah blah criteria is a "search" bar. Looks up the record just fine. Click a button, opens a "confirm you want to do this form". Click a button, on click event is to run an append query, to put that record in an archive, and then a delete query to delete the record from the main table. no problems here. i close the "confirm you want to do this" window. no problem. then the form where i looked up the record and started this whole process gives me a "record is deleted" error every time i go to close it. i've tried "after update" requery, "setvalue to null" and everything else i can think of. i don't know what to do from here.

[ItsMe]

I think you can turn the warnings off globally or do it for specific events via VBA.

I usually call the original form and do a save before the process runs. Then when you gain focus on the form again, there is no change noticed. The save happens while the form does not have focus.

[ck4794]

i'm not sure that's where to go. there is a save before it opens the second form.

it also goes back to the first form where it looked up the record i wanted to delete, and is now showing the #deleted from all the fields that were in that table.

[ItsMe]

Well, I don't know what else I can offer. You can turn off the warning or you can save the form while there is not any focus.