Refresh form data

[ApplePirate]

I have a form which holds data, data on the form can change at any time and i want a refresh action to happen at regular intervals, but because i have linked another form to open on the on timer event i cant have the form close and open in one sweep. so i need something that will just refresh the data, the data is compiled using a query, so i was thinking of using the requery funtion, but dont know if this can used in the event fields of the form design or if i need to put it in some code, if the code is to be used then i also need to point out that i dont know how the on timer event works in VB. please help Never ever, bloody anything, ever

 

[ajdesalvo]

You can set the refresh rate by going to the database window, select Tools, then Options. On the Advanced tab, there is a setting for the Refresh rate, the default is 60 seconds.

Good luck! Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[dan9991]

you can also use a refresh command button that will do trick and allow you to use it when you want to