Access 2007 Query

[M Joseph]

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/tutorial...4c-e77501d4a63b/essential-aspnet-with-ex.aspx

 

[John W. Vinson]

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.

 

[Clement Gulston]

"M Joseph" wrote in message news:[email protected]...