| re: A simple query problem
What you need to use is a parameter query. You do this be entering [Whatever
text to display in popup] in the criteria section of the design window. When
you run the query, a message will pop up asking for the criteria to be
specified.
Mark
"Tero Partanen" <teropa@paju.oulu.fi> wrote in message
news:18984ff1.0405060208.6267b761@posting.google.c om...[color=blue]
> Hi,
>
> I have a small problem with MS ACCESS query.
>
> I want to be able to have a field, where I can input the search
> parameter, and then it will show me all the entires that match the
> parameter. I have done this already (almost) using "Select Query",
> where in the design view I enter the parameter in the "Criteria" field
> of the query (under the field that I'm using for the query), but there
> has to be a more simple way of doing it, ie. just a pop-up box or
> something else where that search parameter (criteria) can be entered ?
>
> regards,
> Tero[/color] |