Can't Requery

  • Thread starter Thread starter Patrick Titus
  • Start date Start date
P

Patrick Titus

I have Access 97. I want to have a button on a form that
will requery a query that provides records for a report.

I tried to make a macro to requery the query object. It
doesn't work. It tells me I may be in a read-only
database, which is not right. It also says that I may be
using a older version of Access. I hope that's not
right. What should I do? Am I going about this wrong?
 
Why do you need to do this? When you open the report the query should run
from scratch. If you have a form open which is based on the same query you
might want to make sure that any changes you've made to any records are
updated before opening the report. There are several ways you could do that
but basically you just want to save the current record.
 
You must log in or register to reply here.

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

Similar Threads

requery from form 13
List Boxes Do Not Requery 5
Requery on a Tab Control - OnClick 3
Re: Requery after you modify the SQL statement in VBA Access? 1
problems with 'cbo's and requery 2
Remain on current record after requery 1
Requery? 1
Requery subforms 3

Back
Top