Form to prompt to run append query

[DaveyEdgar]

Greetings!
How should I set up the following?
Form on front end based on empty query
when end user is done entering data to that query, on close, a form pops up with a button to run an append query to take the new records from the form-based query and append it to a linked table, then delete all the records from the form-based query so it is empty the next time the re-open the front end form.

e.g.
-user opens db and data entry form
-form is based on local query that is empty
-user enters data to query through form
-user is finished and closes
-popup has button to update records
-the records in the query are appended to a linked table
-the records in the original query are deleted

thanks in advance!!!

 

[TheAceMan1]

How are ya DaveyEdgar . . .

And whats wrong with a [blue]bound form?[/blue]

See Ya! . . . . . .

 

[DaveyEdgar]

the form is bound to a query/table that has over 500,000 records in it and growing exponentially, they are call-monitor forms for a call center. The form is pathetically slow, it takes seriously over 90 seconds to create a new record. And when the click on a button to show a different catagory, it can take up to 3 minutes. I need to do something stat.