add select option on rpt writing to multiple queries used in sbrpt

[Guest]

instead of modifying 4 different queries, i would like to add an 'enter here'
option to a report that writes to a 'session year' field in the queries (or
any similar concept) that are linked to the report and it's 3 subreports.

 

[Guest]

You can create a form with objects on it

TextBox where the user input the 'session year'
A Button to open the report, on the OnClick event write

If IsNull(Me.[TextBoxName]) Then
MsgBox "Must select a session year"
Else
Docmd.OpenReport "ReportName"
End If

In the queries you can refer to the text box created

Select * From TableName Where FieldName = Forms![FormName]![TextBoxName]


I hope that what you are looking for

 

[Guest]

Worked brilliantly. Thanks shiploads.

You can create a form with objects on it

TextBox where the user input the 'session year'
A Button to open the report, on the OnClick event write

If IsNull(Me.[TextBoxName]) Then
MsgBox "Must select a session year"
Else
Docmd.OpenReport "ReportName"
End If

In the queries you can refer to the text box created

Select * From TableName Where FieldName = Forms![FormName]![TextBoxName]


I hope that what you are looking for

--
Good Luck
BS"D

instead of modifying 4 different queries, i would like to add an 'enter here'
option to a report that writes to a 'session year' field in the queries (or
any similar concept) that are linked to the report and it's 3 subreports.