Ok I am on the same sheet now
Did as instructed but recieved the following message

Syntax Error (missing Operator) in query expression'(In
Filter:=[Forms]![Empl Forms]![Combo19])'


"Klatuu" wrote:

I don't understand what you mean by "I deleted the field value an re-inserted
it "
Open your query in design mode and delete any criteria in it. You want all
the filtering done from the report. Am I correct in assumint that combo19 is
a control on your form you use to look up a value?
[Forms]![Empl Reports]![Combo19] should be in the Filter property of your
report.

"LT Larry" wrote:

Klatuu
I deleted the field value an re-inserted it but I still get the Combo Box
when I ref the critera control [forms]![Empl reports]![combo19]
Field Properties: under the lookup tab
Display Control: Combo Box
Row Source Type: Field List
Row Source: [forms]![Empl Reports]![Combo19]

Also where do should I put
In Filter: =[Forms]![Empl Reports]![Combo19]

Thank you for your patience


"Klatuu" wrote:

True is the same as Yes, sorry I used the wrong term. It is the programmer
in me.
True = Yes = -1
False = No = 0
Take the drop down out of the query. There should be no criteria in the
query at all.
In Filter: =[Forms]![Empl Reports]![Combo19]
Try this, let me know how it works.

"LT Larry" wrote:

Klatuu
The Filter Properties are
Filter: Blank
Filter On: No
Order By: Blank
Order By On: yes

When I run the Query by its self I get a blank row with a drop down button
in the name field.

I hope thats what you were looking for

I changed the Filter On: to yes and the report retrieves all the records in
the query.
I am working with Access 2000
and do not have the option to set the value to true
"Klatuu" wrote:

Okay, I still don't know exactly what the problem is, but here are a couple
of things you can do.
Post what you have in the filter property of the report, please.
Be sure in your report you have the Filter On property set to true.

Run the query stand alone, I mean without the form or the report open to see
what result you get.

We can make it work!

"LT Larry" wrote:

Klatuu
I took the text off the end of the statement and the report is set up to
filter not the query.

It still is not working. When I run the query with the open form it is still
blank. I also have a dropp down button in the name field of the query but
when I select it the data filed is blank.

Any suggestions:
Thanks

"Klatuu" wrote:

LT,

There are a couple of problems here. First, there is no [Text] property in
VBA. That is VB.

=[Forms]![Empl Reports]![Combo19] is the same as
=[Forms]![Empl Reports]![Combo19].Value
You also may want to take the filter criteria out of the query and put it in
the report as the filter property.

"LT Larry" wrote:

Here are the steps I have already done:
I have created an unbound form (Form 1) with an unbound Combo box (Combo19)
containing Empl names.(control source is Employ tabl). On the form I have
created a command Button to open a report (Report 1).

I have created a query(Query 1) and in the last name field in have entered
=[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using
the expression builder I originally selected "value" in the last block but it
did not work that is why there is the [Text] expression)

I have create a report (Report 1) to open the Query.

Problem: When I use the command button on the form to open the Report (After
a name selection in the Combo box) the report is blank. I then created a
command button to directly open the query from the form and it also comes up
blank. But if I select a name from the combo box and manually open the query
it works fine and if I manually open the report after maunaully opening the
query the report works fine.

I am completely puzzled????

Thanks in advance for any assistance