Open a Single record in a Report

[Simonhtc4]

Hi Guys, need help with try to open a single Plantation report.



On the home page you have a Run Certificates button, click that and it will take you to the Certificates_frm page.
When you click the Run All certificates it runs the report Certificates_rpt for all in the Bidwell_tbl.

What i want to do is select 1 Record from the Bidwell_tbl and open that single record in the Certificates_rpt.

I have been trying to get this to work but i keep failing :-(

is there anyone out there that help with a fix for this?

Regards
Simon






Bidwell.zip

[June7]

Exactly what have you tried and how is it failing - error message, wrong results, nothing happens?

Why is there no code associated with the SingleCertificate form OpenReport button?

This can be done with macro or VBA. Basically the same as the 'all certificates' code except with dynamic parameter that references the combobox.

For VBA example review http://www.allenbrowne.com/ser-62.html

Don't need two queries, one will serve for both reports.

[Simonhtc4]

Hi June, im new to this and will look throught the article you have hyperlinked.

[Simonhtc4]

I really dont understand any of the article to be honest but ill keep having a stab at it.

[Simonhtc4]

Ok, Im getting there slowly but surely.

If you open the SingleCertificate_frm and select a plantation then click run report, it will open the Certificates_rpt BUT........ it only open the report with Plantation name and does bring the data down for that specific plantation, it keeps getting the details for the rest of the report from what ever is at the top of the Certificates_qry.

I hope this makes sense.

I want the report to show all the details for that plantation i select for the report to run the Certificate.


Bidwell_1.zip

[June7]

DoCmd.OpenReport "Certificates_rpt", acViewPreview, , "Plantation='" & Me.Plantation & "'", acWindowNormal

Or you could have used Embedded Macro as you did with the 'all' button and simply apply filter criteria there in the WHERE CONDITION.

I never use macros, only VBA.