Generating Report (1 Viewer)

rendon115

Registered User.
Local time
Yesterday, 19:28
Joined
Oct 24, 2019
Messages
10
Looking to generate a report (InfoReport) off of a subform selection in datasheet view. The subform (SearchSUBFORM) datasheet view displays 4 columns of information stored in a larger table (TagJunction). TagJunction has around 12 columns of information in it, that arent all displayed in SearchSUBFORM.

What I need to do, is generate a report based off the current record selected in SearchSUBFORM, using a button on the Main Form. The report I already have set up to pull the information from TagJunction, but I dont know how to call the report from the button properly.

Such as:
DoCmd.OpenReport "InfoReport", acViewPreview, , "MNumber= " & ???
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 19:28
Joined
Oct 29, 2018
Messages
21,453
Hi. It might be simpler to create a report/subreport setup to copy your form/subform setup, so you can open the main report and the subreport should match your subform automatically.
 

Users who are viewing this thread

Top Bottom