I'm experiencing the error, "This expression is typed incorrectly, or it is too complex to be evaluated." after I add a subform.
I have a text box on the main form that is pulling a category ID from one subform: Control Source =[fsubBudgetDetails01].[Form]![cmbCatID]
The text box, txtCatID, displays the correct value dynamically as I click on line items on the subform fsubBudgetDetails01. But when I add a second subform that I want to display child fields based on txtCatID it returns the error "This expression is typed incorrectly... " The form renders but the second subform is blank.
Second subform name: fsubMonthlyActuals01
Link Master Fields: txtCatID
Link Child Fields: CatID
The field CatID is in the fsubMonthlyActuals01 data set, which is a aggregate query (which shouldn't cause this issue).
I've been building Access forms for over 20 years and this error has me baffled.
I have a text box on the main form that is pulling a category ID from one subform: Control Source =[fsubBudgetDetails01].[Form]![cmbCatID]
The text box, txtCatID, displays the correct value dynamically as I click on line items on the subform fsubBudgetDetails01. But when I add a second subform that I want to display child fields based on txtCatID it returns the error "This expression is typed incorrectly... " The form renders but the second subform is blank.
Second subform name: fsubMonthlyActuals01
Link Master Fields: txtCatID
Link Child Fields: CatID
The field CatID is in the fsubMonthlyActuals01 data set, which is a aggregate query (which shouldn't cause this issue).
I've been building Access forms for over 20 years and this error has me baffled.