Preview only one record (1 Viewer)

[kostaskir]

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 !

 

[pbaldy]

One way:

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

 

[kostaskir]

Thanks for your reply but the link is not active.

 

[pbaldy]

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

 

[kostaskir]

It worked ! Thanks a lot !!!

 

[pbaldy]

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