Hello,
I have a boton on my form that suppose to just print record I am looking at, well its not working and I am almost 100% the code is right....

DoCmd.OpenReport "lease1", acViewPreview, , LeaseID = Me.LeaseID

or for my apartment form boton

stDocName = "Apartments"
DoCmd.OpenReport stDocName, acPreview, , AptID = Me!AptID

can you take at look why its always showing all records not just current record!!

Without opening the db it should be:

DoCmd.OpenReport stDocName, acViewPreview, , "AptID =" & Me!AptID

DoCmd.OpenReport "lease1", acViewPreview, , "LeaseID =" & Me.LeaseID

WOW, I cant believe I miss that from your previous posts!!! Thats where I got the info but missed the quotes!... Anyway thanks for your prompt response.....

I have another issue that you might help me with... I need to print a lease with the info on the lease form. The lease has 10 pages of blablabla... The fields only are used in some pages but I still want to print the whole lease contract.

I noticed that I cant create a long report "10 Pages long of text", I was wondering how could I do this?

I have a post on reports called "Print Lease Contract whole" maybe you can give me a hand on this...

Thanks