I have a query that uses wild cards, what and parameter query box to ask for user input and then shows a report later on.

what I want to do is create a form that override the parameter query box and instead through the form user can input for example name or number and click a button to show the report.

how can I do it?

Thanks in advance.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Essential ASP.NET with Examples in VB.NET
http://www.eggheadcafe.com/tutorials...t-with-ex.aspx

On Fri, 01 Jan 2010 12:10:29 -0800, M Joseph wrote:

>I have a query that uses wild cards, what and parameter query box to ask for user input and then shows a report later on.
>
>what I want to do is create a form that override the parameter query box and instead through the form user can input for example name or number and click a button to show the report.
>
>how can I do it?

Use a parameter query with

=[Forms]![NameOfYourForm]![NameOfTheTextbox] & "*"

as a criterion if you want to return records starting with the text string
entered by the user; use

="*" & [Forms]![NameOfYourForm]![NameOfTheTextbox] & "*"

if you want to find a record with the user's string anywhere within the field.
--

John W. Vinson [MVP]

"M Joseph" wrote in message news:(E-Mail Removed)...
>I have a query that uses wild cards, what and parameter query box to ask
>for user input and then shows a report later on.
>
> what I want to do is create a form that override the parameter query box
> and instead through the form user can input for example name or number and
> click a button to show the report.
>
> how can I do it?
>
> Thanks in advance.
>
>
> Submitted via EggHeadCafe - Software Developer Portal of Choice
> Essential ASP.NET with Examples in VB.NET
> http://www.eggheadcafe.com/tutorials...t-with-ex.aspx
>thank you for that infomation that linked your query