A
Ace9x
I have created a Form > Subform > Subform layout. In the first subform is a
Financial Year text field that I want to be used in the second subform to
control a combo box selection.
Have then created a Where clause in the Row source for the combo box as
follows :-
Where tbl1.financialYear =
[Forms]![frmMain]![subcontrol1].[Form]![txtFinancialYear]
frmMain is the initial form name
subcontrol1 is the first subform control
The entry for tbl1.financialYear causes a parameter request entry to occur??
When I view the code after typing it in manually without any [ and ] around
the tbl1.financialYear column they still appear.
How do I suppress the parameter entry request?
The combo box works ok if I put a valid value in.
Cheers,
Steve
Financial Year text field that I want to be used in the second subform to
control a combo box selection.
Have then created a Where clause in the Row source for the combo box as
follows :-
Where tbl1.financialYear =
[Forms]![frmMain]![subcontrol1].[Form]![txtFinancialYear]
frmMain is the initial form name
subcontrol1 is the first subform control
The entry for tbl1.financialYear causes a parameter request entry to occur??
When I view the code after typing it in manually without any [ and ] around
the tbl1.financialYear column they still appear.
How do I suppress the parameter entry request?
The combo box works ok if I put a valid value in.
Cheers,
Steve