Thanks that worked perfectly > >>Hopefully a simple problem but I am using the default button set from >>the Form Wizard. In the form I have field named "WEEK1" which shows >>the week in a table with a field named "WEEK". >> >>In the print button I put >> >>REPORT FORM NEWSTAFF.FRX FOR WEEK1=NEWSTAFF.WEEK NOCONSOLE TO PRINTER >>PROMPT >> >>Results: Blank sheet of paper. >> >>If I use: >> >>REPORT FORM NEWSTAFF.FRX FOR CTOD("10/06/97")=NEWSTAFF.WEEK >>NOCONSOLE TO PRINTER PROMPT >> >>I get that record to print. >> >>I was hoping to print the record that showed in the form at that >>moment. >> >>Any ideas? >> >>Thanks > >Your mistake is using Week1 variable which essentially means nothing (I >guess) >You should use: >Select newstaff >REPORT FORM NEWSTAFF.FRX NEXT 1 NOCONSOLE TO PRINTER PROMPT