Refresh vs Requery vs Recalc.

[GShen]

I use Refresh alot, but while reviewing something in help I came across Requery again and Recalc. What does Requery do differently than Refresh? I just read Requery does not reset the record pointer (a problem I have been fixing on a lot of forms). What is the downside? And also where does Recalc come into play? Is that just when your records from the query are the same but the data has changed?
running Access 2000 / SQL 2000 ADP's.
If anyone can clearify I would appreciate. I don't want to start putting this in all over the place and find out it does not do what REFRESH does.
Thanks,

 

[xlbo]

GShen - your post is welcome here but you may get a better response if you post it in one of the access forums..

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244

 

[GShen]

thanks I reposted in Acces FORMS.