Pausing OnClick

[amanda_jb]

Can anyone tell me how I can pause until my first command has run? I'm
trying to set the Recordsource data, have the criteria entry run upon doing
so and then a filter run off the criteria which was entered. Problem is
without any type of pause, it replays the Criteria message twice. I'm using
this to do a filter search for data in a different table and the only way I
could come up with was to create a form with the search criteria entered
there. If there's a better way, totally up for hearing that as well. Please
le tme know if I can give better detail, but thought I'd see if I'm going the
right way before I get into it.

Thank you!!!

 

[Arvin Meyer [MVP]]

Try adding a Delay to the code to let the process run:

http://www.mvps.org/access/api/api0021.htm

 

[Arvin Meyer [MVP]]

DoEvents turns all activity over to the operating system, so all code
execution stops. Whereas the api, puts an actual pause in the code for n
period, allowing Access to still be in control.

I use DoEvents when there's an outside process running, like opening Outlook
and adding an attachment.

 

[amanda_jb]

It seems like it will work and I ran the code in a module which worked, but
how do I place this in my code? I saved the code in the module and placed
the Call Sleep (which is what i named the module) where I want my pause and
received an error. Help???

thank you!!

 

[Arvin Meyer [MVP]]

You received an error because you named the module the same as a function
within. Access is now confused. Try changing the module name (not the
function name) to something like:

basSleep
or
modSleep
or even
basUtilities

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com