I have a form that I created that shows all related records in a column report. The report shows a list of Spec Numbers for a given part number.
Here are the column titles:
Spec No Dwg Number Revision Assembly
Record1
Record2
What I want to do is click on the Spec Number, or a button by it, and have a form open for that Spec number on the row I clicked.
I have tried using the Open Report command in a Macro where [Spec No] = [Forms]!<report name>![Spec No]
All I get is a blank form, no fields, no information.
Am I missing a line in the macro? The only line is Open Report.
Thank you in advance.
Im Steven B
Here are the column titles:
Spec No Dwg Number Revision Assembly
Record1
Record2
What I want to do is click on the Spec Number, or a button by it, and have a form open for that Spec number on the row I clicked.
I have tried using the Open Report command in a Macro where [Spec No] = [Forms]!<report name>![Spec No]
All I get is a blank form, no fields, no information.
Am I missing a line in the macro? The only line is Open Report.
Thank you in advance.
Im Steven B