In the past, I've created a report based upon a query that was based upon the Active Form using the EventID (autonumber field) The criteria would be [Forms]![frmEvent]![EventID].
I want to upsize the database to a SQL backend. The query that supports the report won't "upsize because it depends on a Form parameter"
Could I do VBA that says take value of a field in the form and make it equal to the value of the field in the report?
Thanks in advance