Re: using a form with combo box to input criteria


"Al Camp" wrote:

> Christina,
>    When you removed the criteria, and got all records back... did you get 
> prompted at all??
>    I assuming you did not... but we must determine that.
>    That means that, in the query, we don't have another similar parameter. 
> So I'm suspecting that your criteria is not addressing the combo value on 
> the form properly.
> 
>    What is the exact Name of your form, and what is the exact Name of the 
> combobox on that form?  Not the field/s that the combo may display... the 
> actual Name of the Combobox itself.
> 
>    Here's an example.  If you had this setup...
>         Form name = frmMyDialogForm
>         Combobox name = cboNameCriteria
>    Then your criteria in the query would be...
>         Forms!frmMyDialogForm!cboNameCriteria
> 
>    I want to make sure you're referring to the combobox Name in your 
> criteria, not the field name of the value that's displayed/selected.
> -- 
> hth
> Al Camp
> Candia Computer Consulting - Candia NH
> http://home.comcast.net/~cccsolutions
> 
> "Christina" <Christina@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message 
> news:462F8F39-49A2-433C-AAD1-E77063C6E822@xxxxxxxxxxxxxxxx
> >
> >
> > "Al Camp" wrote:
> >
> >> What happened when you followed my previous instructions?
> >> > Leave the form open with a legitimate value in the combo, and run the
> >> > query behind your main report.
> >> Does that work, and only return just the record/s you want?
> >>
> >> If not, remove the criteria from your query and run again.
> >> Does your query return ALLl the records... from which you want to further
> >> filter when we add the criteria back?
> >> -- 
> >> hth
> >> Al Camp
> >> Candia Computer Consulting - Candia NH
> >> http://home.comcast.net/~cccsolutions
> >>
> >> "Christina" <Christina@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:66E1A995-D198-43CF-BF00-F62BAECE5D0E@xxxxxxxxxxxxxxxx
> >> >
> >> >
> >> > "Al Camp" wrote:
> >> >
> >> >> Christina,
> >> >>    If your saying the records returned by the 2 subreports are 
> >> >> controlled
> >> >> by
> >> >> the CustName on the main report, then there's no need for calling the
> >> >> CustName criteria in either subreport.  The Parent/Child relationship
> >> >> bewteen the main and subs will handle that.  The subs should only 
> >> >> display
> >> >> records that match the CustName on the main... by thier relationship.
> >> >>    You should only need a CustName criteria (refering to your form 
> >> >> combo)
> >> >> in
> >> >> the query for the main report.  The subreports by thier relationship 
> >> >> to
> >> >> the
> >> >> main, are slaves to the main report.
> >> >>
> >> >>    But... if you're using just CustName to criteria the records 
> >> >> returned
> >> >> by
> >> >> your query/report, that is wrong.  It may work now, but it's poor 
> >> >> design.
> >> >> You should be using a unique key field value in your Customer table 
> >> >> (like
> >> >> CustID) to associate to other tables, and exactly identify that 
> >> >> Customer.
> >> >> -- 
> >> >> hth
> >> >> Al Camp
> >> >> Candia Computer Consulting - Candia NH
> >> >> http://home.comcast.net/~cccsolutions
> >> >>
> >> >> "Christina" <Christina@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> >> news:30D09720-D586-4D62-A21A-D4C3876D6CE8@xxxxxxxxxxxxxxxx
> >> >> >
> >> >> >
> >> >> > "Al Camp" wrote:
> >> >> >
> >> >> >> Christina,
> >> >> >>    First, don't name a field [Name].  It's reserved word.  Call it
> >> >> >> CustName
> >> >> >> or something like that.  Do that before going any further.  Of 
> >> >> >> course,
> >> >> >> edit
> >> >> >> your form and the report query criteria accordingly.
> >> >> >>           [Forms]![Names]![CustName]
> >> >> >>
> >> >> >>    Next, as I wrote previously in another thread...
> >> >> >> >   If you multiple queries behind your report, only one of them
> >> >> >> > should
> >> >> >> > call
> >> >> >> for the Parameter.  You let the queries deliver "all" records, and
> >> >> >> after
> >> >> >> selecting the fields for the report query, that's where the
> >> >> >> ParameterIf
> >> >> >> the
> >> >> >> "Name" parameter is included in several of your
> >> >> >> queries, you're probably getting a prompt for each one.
> >> >> >> >   Forget about the report right now, and just run the query 
> >> >> >> > behind
> >> >> >> > it.
> >> >> >>
> >> >> >>    Select a legitimate name on your criteria form, and open the
> >> >> >> report.
> >> >> >> While the criteria form is still Open, go into design mode for the
> >> >> >> report.
> >> >> >> Open and run the query behind the report.  Does the query run 
> >> >> >> clean,
> >> >> >> with
> >> >> >> out prompts, and display the data you want?  (using the CustName 
> >> >> >> form
> >> >> >> criteria)
> >> >> >>    If not, then the problem is in the query... so far...
> >> >> >>    If it runs clean and displays the data you requested according 
> >> >> >> to
> >> >> >> the
> >> >> >> form criteria, then try the report (still with the criteria form
> >> >> >> Open).
> >> >> >>    Let us know how you made out, up to this point...
> >> >> >> -- 
> >> >> >> hth
> >> >> >> Al Camp
> >> >> >> Candia Computer Consulting - Candia NH
> >> >> >> http://home.comcast.net/~cccsolutions
> >> >> >>
> >> >> >>
> >> >> >> "Christina" <Christina@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> >> >> news:9CC3456F-9439-44AC-8004-7C168C161720@xxxxxxxxxxxxxxxx
> >> >> >> >I have a query that prompts for input of criteria.  I created a 
> >> >> >> >form
> >> >> >> >(named
> >> >> >> > it NAMES) and created a combo box, from a table that has the list 
> >> >> >> > of
> >> >> >> > criteria. Eg names and SSN. so I can choose the name.  I then put 
> >> >> >> > a
> >> >> >> > button
> >> >> >> > to
> >> >> >> > run the query.
> >> >> >> > In the query criteria I put [Forms]![names]![name].
> >> >> >> > FRom the comco box I choose the name of the person I want the 
> >> >> >> > query
> >> >> >> > to
> >> >> >> > find,
> >> >> >> > but when I click the button the enter parameter bopx pops up
> >> >> >> > showing
> >> >> >> > [Forms]![names]![name] anI still need to enter the name in the 
> >> >> >> > box.
> >> >> >> > What
> >> >> >> > am
> >> >> >> > I missing.
> >> >> >> >
> >> >> >> > Thanks
> >> >> >> > Christina
> >> >> >>
> >> >> >> Thanks.
> >> >> > Let me explain further.  My report actually has two sub reports, 
> >> >> > which
> >> >> > run
> >> >> > on independent queries, for all queries (3) the criteria is NAME.  I
> >> >> > will
> >> >> > change that as per your suggestion.
> >> >> >
> >> >> > To narrow down and test, I created a form to run just one report.  I
> >> >> > put
> >> >> > in
> >> >> > the criteria of the query [forms]![names]![name]
> >> >> >
> >> >> > On the form I created a button to run the report, and a combo box to
> >> >> > choose
> >> >> > the name from.  I choose the name. but when I click to run the 
> >> >> > report,
> >> >> > my
> >> >> > report has headers but no data.
> >> >> >
> >> >> > Christina
> >> >> >
> >> >> >
> >> >> >>
> >> > Please bear with me.
> >> > I understand.  I am new at this , so my design may be cumbersome.
> >> > However,
> >> > like I said in my last post,  I am focussing on just one query and 
> >> > report
> >> > and
> >> > trying to set up the form.  But it does not work  see below
> >> >
> >> > To narrow down and test, I created a form to run just one report.  I 
> >> > put
> >> > in  the criteria of the query [forms]![names]![name]
> >> >
> >> > On the form I created a button to run the report, and a combo box to
> >> > choose the name from.  I choose the name. but when I click to run the
> >> > report, my
> >> > report has headers but no data.
> >> > Christina
> >> >>
> >> >>
> >> >> I did as you instructed.  The query prompts for a criteria, with the 
> >> >> ENTER  PARAMTER BOX showing Forms!Names!name. If I dont input a value 
> >> >> I get a blank query. When I remove the criteria from the query, ALL 
> >> >> records are returned.
> >>
> >>
> >> I thought you had given up on me!!
answer to your question: When I got all the records I did not get a prompt.

I renamed my form and used your example as above.  Put the criteria as above 
in my query.  Right click on the combo box , in property put the name as you 
have above. Open form.   I select a name, and when I click, I get all the 
records. 
 My combo box is based on one of the two tables in the query.

So I have ensured that the criteria in my query is referencing the combo 
box.  Before, it was as you mentioned, it was referencing the name of the 
field.

However it still does not work.


> 
> 
> 
.
Loading