Re: Use a form to query a report

Tech-Archive recommends: Speed Up your PC by fixing your registry



I am not real clear on the section below.

In the parameter query (design view) set the parameter to:
LIKE Forms!frmFind!txtDOB
OR Forms!frmFind!txtDOB Is Null
for each field (using the appropriate control name from frmFind). This
will
work for maybe 5 or 6 criteria. If you need to do more than that you
may
need another approach, but since you have not been specific I will
leave it "

I do have six fields I would like to put on the form. When I create
the unbound form and then the unbound text fields I can click open the
properties and then click on the event procedure and it will bring me
up to a query, but all the fields in the column are blank. What do I
need to do from here to complete the parameter query according to your
instructions. This is where I am getting stuck.

.



Relevant Pages

  • Re: Displaying data from 3 tables in unbound form
    ... >criteria for a parameter query and then use the query to ... >customer and address tables. ... I then need to display ... >categories for a customer using an unbound form? ...
    (microsoft.public.access.formscoding)
  • Re: Multi-Field Parameter Query
    ... A design that gracefully supports what you consider "exceptions" ... They could also enter Excel or word in any of the other software ... > I'd like to create a parameter query to ask 'who has Word'? ... > I don't want 7 pop ups. ...
    (microsoft.public.access.queries)
  • RE: crosstab query with parameter query
    ... You probably need to open up the parameter query in design view. ... Date/Time in the second column. ...
    (microsoft.public.access.queries)
  • Query Design
    ... I have a very basic database with two tables for a sports club. ... I want to design a parameter query which will ask for a name. ...
    (microsoft.public.access.queries)
  • Re: a Query that collected parameters from a form just stopped working
    ... > My parameter query was working perfectly.. ... > form/parameters by asking me for the paramaters over and over again? ... > WebDude ... Prev by Date: ...
    (microsoft.public.access.queries)