Problem with subsubform Rowsource Where clause

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top