Is it possible to modify the Recordsource of an existing report via VBA in a form? I have a Report in MS Access 2010 that has a number of different variations. The data elements on the report are the same the differences are in the Where clause of the SQL. I have a form so the user can select which fields are to be used for the criteria of the report. Now I need to be able to modify the Recordsource of the report so match those selections. Which is complete I just can't seem to figure out the code to modify the recordsource. from the form. Access version is 2010
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Report RecordSource Modification in VBA of a form Question
- Thread starter Ray1127
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question