How to get form information into a Report

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.
 
F

fredg

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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top