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= " & ???
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= " & ???