Refresh query

[bknight]

What would be the syntax for refreshing a query that is not in focus?

[HansV]

That's not possible as far as I know. You'd have to close it and reopen it, but that would defeat the purpose, I guess.

(You don't want to hear this, but you should only use forms and reports to present data)

[bknight]

Well then what would be the syntax to refresh a form not in focus?

[HansV]

If you want to update the records that are already displayed in the form, that would be

Forms![NameOfTheForm].Refresh

If records might have been added or deleted, use

Forms![NameOfTheForm].Requery

to show those changes too.

[bknight]

Well since I can't refresh queries with code, which seems odd, I'll make some forms out of the queries and d it that way. One small nuisance, though I will have to change the criteria on the query to make form display what is needed. With just the query, I change the date and then hit the little refresh all button. I was attempting to refresh after a profit was recorded. So I guess it is six of one and a half dozen of the other.

[HansV]

You could use a text box on the form in which you enter the date.
Either use the After Update event of that text box, or the On Click event of a command button on the form to filter the form based on the date.

[bknight]

Here is the form in design view, where would I put a text box so it shows in DS view, like the second image??

[HansV]

This won't work in Datasheet View. You'd have to create a main form in Form View with a subform in DataSheet View.
Alternatively, use a continuous form that you design to look like a datasheet form.

[bknight]

I don't know how to do any of that so, the idea is scrapped and I will trfresh the query manually, thanks.