I have a subform embedded in a form.
I want to use the DLookup function on a field contained in the subform. I'm getting various errors that I believe are due to the fact that I am incorrectly referencing the fields in my subform.
I'm reasonably certain this is the case because if I open the subform by itself, my DLookup function works correctly. It's only when I open the master form that I run into problems.
I believe my question may not even be specific to the use of the DLookup function so could someone guide me on how to properly reference fields when using/creating functions that reference fields in a subform. i.e. do I need to (and if so, how) reference the master form in my function?
And is there is difference in referencing fields when the subform is formatted as a datasheet vs. continuous forms or even single form?