Form issue

  • Thread starter Thread starter Tara
  • Start date Start date
T

Tara

I have a form with two combo boxes. These combo boxes
are used to set criteria for several reports. In combo
box 1 you choose the report you want to run, in Combo 2,
you choose the staff member. I have a command button to
pull the reports after the criteria is set. All
underlying queries are set to accept the criteria on the
form and limit it accordingly and also to pull data for
all staff if combo 2 is left empty. All reports but one
work. Even that one works if Combo 2 is left empty. If
I run the reports without using the form, it works,
whether I limit the staff member or not. Anyone have any
ideas of what's going on here...I'm stumped!
Thanks!
Tara
 
Hi Tara

probably restating what you've already done but i would start off my
rebuilding the criteria of the query that doesn't work (using the expression
builder) and also check that the report is set to use the correct query ....

Cheers
JulieD
 
Back
Top