To print the selected information from the form along with other information

[narasimharaosama]

Hello,

I have a form called "New Proposal".I enter the data in the form and
hit the submit button to enter it into the table for new proposal.Now
I want to print out a letter with some of the fields information
entered on the form along with some fixed data that should be there on
it always.
the letter goes like this
To
Dept Of Research and Graduate Education,---------fixed
College of Pharmacy------------------------------------------fixed


Date Recd-----------------------------------from the present data
entered in form ( as u know changes from one entry to other
PAF#-------------------------------------------------------from the
present form data
Title---------------------------------------------------------from the
present form data
Agency-----------------------------------------------------from the
form

The budget has been checked by---------------some name----fixed

I hope someone can help me out with this.

Thanks

Sama

 

[Carl Rapson]

Hello,

I have a form called "New Proposal".I enter the data in the form and
hit the submit button to enter it into the table for new proposal.Now
I want to print out a letter with some of the fields information
entered on the form along with some fixed data that should be there on
it always.
the letter goes like this
To
Dept Of Research and Graduate Education,---------fixed
College of Pharmacy------------------------------------------fixed


Date Recd-----------------------------------from the present data
entered in form ( as u know changes from one entry to other
PAF#-------------------------------------------------------from the
present form data
Title---------------------------------------------------------from the
present form data
Agency-----------------------------------------------------from the
form

The budget has been checked by---------------some name----fixed

I hope someone can help me out with this.

Thanks

Sama

In your form, just before you save the record save the key value of the new
record in a variable. Create a report that looks like the letter you want.
Base the report on a query of the table but with no WHERE clause. In your
code, after you save the new record, use DoCmd.OpenReport to open the report
and pass the key of the new record in the WhereCondition parameter:

DoCmd.OpenReport "my report", , , "[Primary Key] = " & Me.Key_Value


Carl Rapson