working like i want-
Step one:
Use a form to search for the record I want (I've tried using the table itself as the source, and an independent query)
step two:
once the appropriate source is selected, click a button, which saves record (there's a date to update from here) and then open a "confirmation" i made. a "are you sure you want to do this" type page.
step three:
click the confirm button. runs an append query, to copy the record to an archive table. then runs a few delete queries, deleting the record from the child tables, and then the master table. closes window.
PROBLEM
when closing the first form that found the record, i get the "record is deleted" error and all #deleted in the text boxes. i've tried requery, refresh, and everything else i can think of, but i can't find a way to close this form, after i've deleted the record, and not get an error.
any help is appreciated.
Step one:
Use a form to search for the record I want (I've tried using the table itself as the source, and an independent query)
step two:
once the appropriate source is selected, click a button, which saves record (there's a date to update from here) and then open a "confirmation" i made. a "are you sure you want to do this" type page.
step three:
click the confirm button. runs an append query, to copy the record to an archive table. then runs a few delete queries, deleting the record from the child tables, and then the master table. closes window.
PROBLEM
when closing the first form that found the record, i get the "record is deleted" error and all #deleted in the text boxes. i've tried requery, refresh, and everything else i can think of, but i can't find a way to close this form, after i've deleted the record, and not get an error.
any help is appreciated.