ok fellas

this thing is really bothering me ALOT

ok... how do i show ONLY one row in the report, not ALL of them

example: i only want to show one of my student name with its details not dont want the other students details popped up on the same page after the student details....

please help me, this is extremely, EXTREMELY urgent

thank you

Using quotes like "this is extremely, EXTREMELY urgent" "help me please - this is totally urgent" will not help you to get any helpfull replies.

Take into account that this forum exists by the grace of volunteers.

RV

Mmm, another helpful answer

Jade,

How are you displaying your record on the report. are you using group headers and the like? If so, have a look in the properties section of the Group header and change the Force New Page entry.

If you are using a comand button from a form, then its just a case of using some code to print the current record from the screen based on the current record ID


Dim strDocName As String 'Sets the report to print the current record on the screen
Dim strWhere As String
strDocName = "Invoice" 'Report Title
strWhere = "[CustomerID]= " & Me!CustomerID
DoCmd.OpenReport strDocName, acPreview, , strWhere

ok guys, i do not use group headers. i will show you one screenshot. This still need to be fixed.

i want it only show one row, not all of them :P

if no one helps me out, my boss is going to kill me

if no one helps me out, my boss is going to kill me
Then he'll get a number of years in jail. Are you sure he has thought that through? You might want to sit him down and tell him why it would be wrong to kill you.

A member already came to your rescue, here's a brief synopsis,
use the WHERE clause of the OPEN REPORT method.
Both the Access help file and posts here have numerous examples that you can use to defend yourself with

Thanks Mousemat, I've been searching to find the correct syntax for getting mine to print only the current record from a form and your example was the simplest I've found and worked like a charm.

Thanks again, Lori

Thanks Mousemat, I've been searching to find the correct syntax for getting mine to print only the current record from a form and your example was the simplest I've found and worked like a charm.

Thanks again, Lori


LLB

Always a pleasure to help someone