Get current record only to show on report

[Stockwell43]

Hello,

I have a form to input data. On the report Details sections I copied all the
field from the form. When I click on the report, it shows all the records and
prints all the records. I only want it show the current record the form is on
and print only that record.

Thanks!!

 

[MikeJohnB]

A report is virtually the same as a form, your form is selecting all the
records but displaying the one you want to print.

Having said that, base your report on a query. You can set the Control
Source to the query the same as you can a form.

In the query, right click in the criteria row and select build, use the
expression builder to select a unique control on your form, (Select loaded
forms Your form name the control name),(the value in a combo box used to
select the record?)

Once that is done, your report will only show one record and print one record.

I hope I have explained this carefully enough, no doubt there are other
menthods but that is how I do the job.

Does this help? Let me know.

Kindest Regards

Mike B

 

[NewSysAdmin]

I was looking to do the same thing, and this was the easiest solution I could
find as I'm not very strong in Visual Basic, but have done quite a bit with
queries. Thank you!

 

[MikeJohnB]

You're welcome

Cheers