Re: using a form with combo box to input criteria

Hope you read this before sending the mdb.
Is part of your email address...
chave?????@yahoo.com
and you sent the file on 2/1/06?

If so, then your email address is listed as a spammer by the SBL+XBL
database, and that's why it kicked out.
I'll "whitelist" you so when you resend I should get it.
If I'm wrong about your email address, then just give it another go...
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


"Christina" <Christina@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:638C8CFC-A234-4C0F-BBB7-21578CD3AF17@xxxxxxxxxxxxxxxx


"Christina" wrote:



"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





Hi,
Did you get a chance to look at the Dbase.

Thanks




.