Refreshing a query


P

Phil Hibbs

How do you refresh a query? DoCmd.OpenQuery just opens it, I want to refresh it. The query has a where clause that refers to a box on a form, and whenI change the value in the form I want to refresh the query results. The DoCmd.Requery command seems to want a control and not a query.

Phil.
 
Ad

Advertisements

Joined
Feb 4, 2015
Messages
1
Reaction score
0
How do you refresh a query? DoCmd.OpenQuery just opens it, I want to refresh it. The query has a where clause that refers to a box on a form, and whenI change the value in the form I want to refresh the query results. The DoCmd.Requery command seems to want a control and not a query.

Phil.
Me.requery, Phil.
 

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

Refresh Tables and Queries 8
Form Query Refresh 1
Refresh a form's backend query 0
How to Find / Query / Refresh form 1
Refreshing... 1
Refresh 1
Refresh 4
Refresh 2

Top