Re: Using a dialog box from a query in a form
- From: "Mark" <mreed1975@xxxxxxxxxxxx>
- Date: Thu, 28 Jun 2007 19:27:20 +0100
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@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:1183047703.306009.209360@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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
.
- Follow-Ups:
- Re: Using a dialog box from a query in a form
- From: dympna
- Re: Using a dialog box from a query in a form
- References:
- Using a dialog box from a query in a form
- From: dympna
- Using a dialog box from a query in a form
- Prev by Date: Excel Crashing when opened from Access
- Next by Date: Re: Find error code
- Previous by thread: Using a dialog box from a query in a form
- Next by thread: Re: Using a dialog box from a query in a form
- Index(es):