Is this possible? I have a SQL statement stored in a module that I would like to call as a record source for several forms. I tried this but it didn't work.
In the OnOpen event of the form I put the following code:
Call PCSub_RS2 'Name of Public Function where SQL statement is
Me.AAAsubform.RecordSource = SQl
Me.AAAsubform.Requery
In the OnOpen event of the form I put the following code:
Call PCSub_RS2 'Name of Public Function where SQL statement is
Me.AAAsubform.RecordSource = SQl
Me.AAAsubform.Requery