Problem with subsubform Rowsource Where clause

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
 
G

Guest

Please ignore question as error was down to a typo in the tbl1.FinancialYear
clause
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top