Preview current record

[ChoonBoy]

I am working on a single form with many records.
When I preview my form I would like only the selected record to be
displayed. At the moment it goes to the 1st record. I do not want to preview
using a report.

Any help is appreciated.

Thanks

 

[Allen Browne]

Use the WhereConditon of OpenReport.

Example in:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

 

[ChoonBoy]

Thanks Allen for the quick response.

Instead of using Report, can I preview only the record using the form.

Thanks & Regards

 

[Allen Browne]

Not very easily.

It's easier to create the report laid out exactly as you want it.

(Start by saving the form as a report if that helps.)