Using a dialog box from a query in a form

[dympna@crosslandtankers.com]

I have created a dialog box in a query that will prompt the person to
input the parameters they want to stipulate the query to search on...
I have created a form based on this query, everthing works well and
when you open the form it prompts you to enter your parameters,.
But my question is how do yo get that dialog box prompt to appear
again without having to close and open the form each time you want to
perfom a new seacrh based on new criteria?


Any help would be appreciated...



Thanks

[Mark]

Re: Using a dialog box from a query in a form

I would have thought that you could create a command button on the form. In
the 'On Click' event of the command button, put the following code:

DoCmd.Requery

This should requery the source of the form which will call your parameter
query.

Hope this helps,

Mark

<dympna@crossla ndtankers.comwr ote in message
news:1183047703 .306009.209360@ q69g2000hsb.goo glegroups.com.. .

>I have created a dialog box in a query that will prompt the person to
input the parameters they want to stipulate the query to search on...
I have created a form based on this query, everthing works well and
when you open the form it prompts you to enter your parameters,.
But my question is how do yo get that dialog box prompt to appear
again without having to close and open the form each time you want to
perfom a new seacrh based on new criteria?
>
>
Any help would be appreciated...
>
>
>
Thanks
>

[dympna@crosslandtankers.com]

Re: Using a dialog box from a query in a form

On 28 Jun, 19:27, "Mark" <mreed1...@ntlw orld.comwrote:

I would have thought that you could create a command button on the form. In
the 'On Click' event of the command button, put the following code:
>
DoCmd.Requery
>
This should requery the source of the form which will call your parameter
query.
>
Hope this helps,
>
Mark
>
<dym...@crossla ndtankers.comwr ote in message
>
news:1183047703 .306009.209360@ q69g2000hsb.goo glegroups.com.. .
>
>
>

I have created a dialog box in a query that will prompt the person to
input the parameters they want to stipulate the query to search on...
I have created a form based on this query, everthing works well and
when you open the form it prompts you to enter your parameters,.
But my question is how do yo get that dialog box prompt to appear
again without having to close and open the form each time you want to
perfom a new seacrh based on new criteria?

>

Any help would be appreciated...

>

Thanks- Hide quoted text -

>
- Show quoted text -

Thanks Mark, took me a moment on how to work this properly but it
works a treat...

Thanks very much