refreshing a query

[tealeaf]

Hi i already have a maketable query. what is the vba code for refreshing? the query uses the "NOW()" function, thus everytime i call the Sub i'd like to refresh the table.
thanx

 

[coyotem78]

Isn't it "Requery"

 

[Jack_58]

Correct Requery is calling the recordset Close method and then calling its open method again with the orginal data

you might also try "Resync: This resync'sx the records in your recordset with the underlyind database.

Hope this helps.

Let me know


Jack

 

[tealeaf]

ok i'm really a beginner here. if i do want to use requery, how would i go about doing that?
say my queryname of the maketable query is "query1"
so far i have
dim rst as dao.recordset
set rst = currentdb.openrecordset("query1")

the second line of code produces an error. i tried it with another query, a regular query with no maketable, and it works. to use requery it should look something like
rst.requery right?
but to what do i set rst first?

 

[Jack_58]

The best way to do a Requery is to write a Macro. Go to Macros and select Requery from the Action Drop Down Dialog box. Next enter the control you are attempting to requery and Select the Control to have the action take effect on.

You can also write VBA for the Requry as follows,

Sub RequeryList()
Dim ctlList As Control

' Return Control object pointing to list box.
Set ctlList = Forms!Employees!EmployeeList
' Requery source of data for list box.
ctlList.Requery
End Sub



Please let me know if this helps you.



Jack

 

[tealeaf]

thanx jack
i'm not really sure if that will work given that i'm not working with "controls" but rather with a query i made. it's that query i want updated. is that possible? also i want to be able to update the query with an assigned date now. for example i want to be able to pass a date as an argument to this function, which will update the query.
but thanx so much for your suggestion
T