tommycrock
Registered User.
- Local time
- Today, 07:41
- Joined
- Feb 13, 2013
- Messages
- 13
If I enter an expression with optional criteria as the Default value for a control, so the first criterion is missing and the second isn’t, I get the following error:
e.g. using Allen Browne’s ELookup function (ELookup(Expr, Domain, [Criteria], [OrderClause])
I don’t want to enter criteria, so I enter:
This works in VBA code so why not from a property box? Or is there a way around this other than writing an alternative function that doesn't ask for the optional criteria and calls the one you want?
Thanks!
This doesn’t happen in code.The expression you entered contains invalid syntax.
You may have entered a comma without a preceding identifier
e.g. using Allen Browne’s ELookup function (ELookup(Expr, Domain, [Criteria], [OrderClause])
I don’t want to enter criteria, so I enter:
Code:
=ELookup("[decisionID]", "qryDecisionStudy"[COLOR=Red][B], ,[/B][/COLOR] "decisionID")
Thanks!