Upon review, I don't think I stated my problem as well as I could have. Let me try again.
A sample of the code in a form variable that is problematic, is as follows:
=DLookup("[ADescription]","2004SpendAuth","[FiscalYr]=forms![2004CombinedAuth]![FiscalYr] and...
Using the "Me" syntax within VBA works fine. However, I have tried unsuccessfully a dozen variations of syntax to achieve the same thing in forms. For example: Within a form field that uses the dLookup function which uses values from the form. The only way I've gotten it to work is to explicitly...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.