Hi,
What i have is a DB with one main table, I have a main data input form and from here i wish to print reports.

Once someone has entered data in the form and added it to the table i would then like to be able to click a button that will copy the record from the table to a report (Pre built to my specs) and print.

However in addition to this i dont want the program to keep the populated form after printing.

it will also be beneficial to have a pop up to select the specific record and to preview the report before it prints??????

I have been banging my head with the Macros to attempt to do this but am not really succeeding, i am using access 2000.

Any suggestions?

Bev :confused:

Ok, after many more attempts i have solved the problem and as it happens there was no Macro in sight.

I am actually embarased as to how siple it was:

I created a lookup query with a criteria int he relevant field to coose the specific record, this then gave me the pop up that i required to choose which record to print, i then created a report with various boxes linked to the query.

Now when i select to print from my master input form i am asked which record to print, i enter in the two digit number (autonumber on my records) and then it will print int he right format that i have created and not save anything on my report :D

Like i said the solution is so simple once you know how!