[AccessD] Force Query to recalc using code.

_______________________________________________________________________________________

Note: This e-mail is subject to the disclaimer contained at the bottom of this message.
_______________________________________________________________________________________


Hi Everyone,

I am updating a MS Access database that was largely built by someone else.  In this database there are lots of pre-built queries, sorted as queries.  I seems that a process is failing as I need to force the query to update before the code does something with it.

I though I would use query def for this, but I cannot seem to figure out the syntax.  Normally I would just call the data I want from a RS using Code, which is always based on the latest data.  This query business seems to be a bit flakey in places.  Actually it is probably more the way the data is being updated into a bound form, the recordsaved and then the query run that is the issue.

Anyway.  What I would like is something like "qryMyQuery.Refresh" in the code to force it to update.  Advice with this is appreciated.

cheers
Darryl.
_______________________________________________________________________________________

The information transmitted in this message and its attachments (if any) is intended 
only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material. Any review, 
retransmission, dissemination or other use of, or taking of any action in reliance 
upon this information, by persons or entities other than the intended recipient is 
prohibited.

If you have received this in error, please contact the sender and delete this e-mail 
and associated material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or distribute 
the information contained in this e-mail and any attached files, with the permission 
of the sender.

This message has been scanned for viruses.
_______________________________________________________________________________________