Print one record only from Form to Report

  • Thread starter Thread starter Marty
  • Start date Start date
M

Marty

While I am in Form view, creating a record (For
Example: Record #50), I want to print only this specific
record from Report. What is occuring... It is printing
all 50 records that have been created instead of just
record #50. How do you resolve this problem?

Thank You very much.

Sincerely,
Marty
 
Marty said:
While I am in Form view, creating a record (For
Example: Record #50), I want to print only this specific
record from Report. What is occuring... It is printing
all 50 records that have been created instead of just
record #50. How do you resolve this problem?
Click to expand...


There are a couple of ways to print the report from a
command button on a form.

The common way is to use the OpenReport method's
WhereCondition argument:

DoCMD.OpenReport "reportname", , , "keyfield = " & keyfield

Another is to use a criteria like Forms!theform.keyfield in
the report's record source query.
 
Back
Top