sines_jl said:
I am trying to save a single record from a table to a report is this
possible?
You can't "save" a record to a report, because report's don't contain
data; they merely report the data that is contained in tables or
extracted from tables by queries. However, you can open a report with a
filter to print (or print-preview) a single record, provided that the
record has a unique key -- or combination of keys -- that can be used to
identify it.
One common situation is that you want to report the record that you are
currently viewing on a form. For example, if the record's key is in the
field named "ID", then the code (for the form) to open report "Report1"
in print-preview mode and show that record woulod look like this:
DoCmd.OpenReport "Report1", acViewPreview, , "ID=" & Me!ID
