Report based of Form Values

  • Thread starter Thread starter mattmanp
  • Start date Start date
M

mattmanp

I have a form with four combo boxes. I use these to choose wha
Client, ChargeType, month (Month(Date)) and year (Year(Date)) t
generate the report with. I had just been usin
"=[Forms]![frm_Calendar]!Client" to do this, but this causes problem
because when the report is generated I have to close the form to se
the report. The problem is that it looks ok on the screen because i
was built when the form what open, but if I try to print it doesn'
work correctly, giving #Error any time one of those reference
existed.

Is it better for me to find a way to minimize the form until th
report is closed (and if so, how?) or to find a different way to ge
that data to the report?

Thanks a bunch
Mat
 
If the report is using the form's data (controls), then you cannot close the
form --- you must leave it open and simply hide it! You can minimize the
form for a while.
 
I assume the report is being launched from a button on your form? You could
hide the form when the button is clicked, then close the form on the Close
event of the report.

If you wanted to do things more elegantly you could store the combo box
values in variables within the report when it opened. I am not sure exactly
how you are using the values from the combo boxes, as once you store them in
variables, getting to them will depend on whether you are referencing them
from a query, showing them in a control on the report, etc.

Hope that helps.
 
I am using them both in control boxes and a query. I am going to tr
minimizing first, I just thought it was wierd that i couldn't vie
the report without closing the form first. Thanks for the advice
 
When I minimize, I see the report fine, but when I try to click on i
the computer beeps at me. I can't use any of the buttons until
close the form, the report still looks fine, but it gives me #erro
everywhere when I print. Any ideas
 
Back
Top