see Deleted # after run Delete and append query

B

babs

I have a command button with a macro tied to it that runs 1st a delete query
and then an append query to refresh a JOBs to Be at list(TABLE). the queries
run Fine but I need to close and reopen the Form based ont this table to get
rid of the delete # records and see the new records. where do I put code on
the After update of the form - I tried me.refresh on the after update event
of the form but sitll need to close and reopen form.

what am i missing?
thanks so much,
Barb
 
J

John Spencer

Refresh only updates the existing records in the current selection. Since you
have added and deleted records you should consider using REQUERY instead of
REFRESH.

I would run the requery immediately after running the queries.

If you are using a macro and not VBA code, I think you can just select the
Requery action and leave the control name blank. That should requery the
source of the current object (form or report).

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top