Re: using a form with combo box to input criteria


"Al Camp" wrote:

> Christine,
>    Of course, this is "no charge", and all data will be treated as 
> confidential...
> -- 
> hth
> Al Camp

Thanks.  Very appreciated.
> Candia Computer Consulting - Candia NH
> http://home.comcast.net/~cccsolutions
> 
> "Christina" <Christina@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message 
> news:FB82EA8C-3DA0-4E39-A457-A445F5CAC644@xxxxxxxxxxxxxxxx
> >
> >
> > "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.
> >
> >
> >>
> >>
> >> 
> 
> Thanks Very Much
> 
.
Loading