Hi,
I have an access 2002 report whose RecordSource property is a query, and which contains a textbox whose ControlSource property is a user-defined function like this;
=AccountHolder()
How do I refer to fields in the query from within the AccountHolder() function? Eg.
Private Function AccoutHolder() as String
'Code here to return the Name field of the report's query.
End Function
I had expected to be able to use Me!Name like on a form, but it raises an error - "... can't find the field xyz"
Thanks.
Enter your message below
Sign in or Join us (it's free).