Report from a form

[fredk]

I have a link to our mainframe which holds sales information. We send out approval letters to each client upon approval of the group. The database holds all of the product information but does not hold the name and address of the group, just a group number.

I want to create a form that populates all of the data needed from the table, plus allow the person to enter the group name and address. I then want to print an approval letter that is sent to the group from this form.

I set up the form with all fields I need and unbound fields for the address information - The problem I have is running the report at this point. I thought maybe I could creat another query and use the forms information but that is not working.

How do I genereate the report using the information from the table and the address that will be input on the form???

Thanks in advance for the assistance!!!!

 

[dynamictiger]

Set up the fields on the report as equal to the fields on the form and do not close the form.

 

[fredk]

Thanks dyamictiger! I appreciate that!!!!