Creating a Report from the active form (Acc2000)

**pvan** · 2002-09-25 20:14

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"
Any ideas?
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

PVan

**charlotte** · 2002-09-26 02:21

Reports and forms don't "upsize", although the queries they're baed on may. Is that what you're talking about?

Thread: Creating a Report from the active form (Acc2000)

Thread Tools