Hello everybody,

I use Access 2007. I created one Split Form and through a "Preview" Button I want to open a report with only the current record.

My problem is that on the report I see all the records. Any ideas ?
This is for my job and it is quite urgent. Any help it would be highly appreciated !!!!!!!!


Thank you in advance !

One way:

http://www.baldyweb.com/wherecondition.htm

Thanks for your reply but the link is not active.

Really? I just clicked on it and it worked fine. Here's a picture of it:

It worked ! Thanks a lot !!!

Glad it helped. Hope things have calmed down over there. Sounds like there has been some "excitement" lately (riots and such).