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.
 
B

bobdog

Joined
Feb 4, 2015
Messages
1
Reaction score
0
Phil Hibbs said:
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.
Click to expand...

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

Executing a hidden query 1
PLEASE HELP: Refresh a subform 5
Form doesn't refresh based on combo box value 4
Prevent Full String Selection after Change Event on Control 1
Refreshing form with all records 4
Access 2K: Refresh Combo Box after adding new data from another fo 2
Refresh Combo Box on Main Form / Subform 3
Refreshing a subform 2

Top