Access 2007 Query

  • Thread starter Thread starter M Joseph
  • Start date Start date
M

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
 
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?
Click to expand...

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.
 
Back
Top