yet again form and report

[caleb]

i need to be able to do is have a button on a form, where
i can just send all the present data (in the form) to a
report, and then open up new data on the form, and be able
to send that to the same report (like creating an invoice)
and then be able to print off that report with just that
data...

 

[Dirk Goldgar]

i need to be able to do is have a button on a form, where
i can just send all the present data (in the form) to a
report, and then open up new data on the form, and be able
to send that to the same report (like creating an invoice)
and then be able to print off that report with just that
data...

You're not going to be able to do that without having some mechanism
whereby you record what records are supposed to be included on the
report. For example, you could have a Yes/No field, "IsSelected", in
the table, initialize this this field to False for all records, then set
it to True for each selected record, and ultimately print a report based
on a query that selects only those records with IsSelected = True. Or
you could have an intermediate table where you stick the data until you
print the report. That is, you could have a table named, say
"ReportData", run a delete query to empty this table before you begin,
and then every time the user clicks a "Select For Report" button you
copy the current record to that table. The report could than be based
on the ReportData table, rather than the original table.

 

[tahsinalp]

i need to be able to do is have a button on a form, where
i can just send all the present data (in the form) to a
report, and then open up new data on the form, and be able
to send that to the same report (like creating an invoice)
and then be able to print off that report with just that
data...