Reports based on forms

  • Thread starter Thread starter w
  • Start date Start date
W

w

HI!

I was wondering if there was any way that I could create
a report based on information that is strictly entered
into a form. I have a form that contains a part where
the fields come from a table and another part where the
fields do not come from a table. I tried creating a
query where I made up expressions like
Forms![form name]![field name] but that did not seem to
work when I tried to put those fields from the query into
the report (especially the fields without any tables) Is
there any other way to do this?

Thanks!!!
 
Would this be a one-record report? It could be done, if you base the report
on the same record displayed in the form and pick up the unbound fields in
VBA code in the Print event of the Detail Section of the Report.

If it is for more than a single record, then you need to clarify about the
"fields just entered in the form".

Larry Linson
Microsoft Access MVP
 
Back
Top