How to get form information into a Report

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have a simple database where I'm entering information into a form and the
have a query & report setup so that when clicking on the report button it
should put that information into the report format that I need. The problem
that I'm having is that the report is blank unless I click back on the
previous record and then go back & try it again.

I'm sure there's an easy solution to this but my limited knowledge of Access
is preventing me from determining the problem, any help you can offer would
be appreciated.
 
I have a simple database where I'm entering information into a form and the
have a query & report setup so that when clicking on the report button it
should put that information into the report format that I need. The problem
that I'm having is that the report is blank unless I click back on the
previous record and then go back & try it again.

I'm sure there's an easy solution to this but my limited knowledge of Access
is preventing me from determining the problem, any help you can offer would
be appreciated.
Click to expand...

If you are trying to run a report with newly entered records, you must
first save the records before opening the report. Records are not
saved unless you go to enter another new record, go to a previously
entered record, close the form, or explicitly save it.

If you are opening the report from a command button on the form, code
the click event:
DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "ReportName", etc.
 
Back
Top