See:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html
The article discusses how to use RunSQL or Execute to fire off an action
query.
If this is actually a SELECT query instead, see:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<ja******@gmail.comwrote in message
news:11**********************@i3g2000cwc.googlegro ups.com...
>i am trying to make a form work using ms-access. i have a form and
queries defined. i need to access form variables from a query and also
would like to execute a query as event in one of the form text box.
any help on this would be greatly appreciated.