Problem with report production

  • Thread starter Thread starter alibachani
  • Start date Start date
A

alibachani

I'm using MS Access (2002)'s instructions to create a report using
input on a form by using macros. However, the report won't display:
that is, after I click OK on the form, I just get a blank screen. If I
click on the query the report is supposed to get its data from, the
query returns what the report shld have displayed (even thgh the form
is now not there). When I double click on the Report, it just goes back
to displayin the form I have connected the report to. Any suggestions?

Also, is there a simpler way to do this rather than use macros? That
is, can I just put something in DoCmd when opening a report so that the
right query is executed and the report is thus created correctly?
 
You can use DoCmd.OpenReport to do it, as long as the query behind your
report is dynamic (i.e. you don't need to run any kind of update query
to get your results). The report will update itself based on the query
results.
 
I would do this, except as stated, I'm using macros, and when I click
on the option for 'On Click', it only displays the macro option.

Plus, when I click on the report, it just gives me the same form again
asking me to input the data option, instead of creatin the report.
 
You know how to use the RunCode macro option?

I would do this, except as stated, I'm using macros, and when I click
on the option for 'On Click', it only displays the macro option.

Plus, when I click on the report, it just gives me the same form again
asking me to input the data option, instead of creatin the report.
Click to expand...
 
Back
Top