View Single Post
  #1  
Old May 17th, 2005, 01:55 PM
LT Larry
external usenet poster
 
Posts: n/a
Default Form/Query/Report problems

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