I have a form bound to a query. The query result has a field that I would like to reference, however I do not want the field on my form. Is there a way to reference a field in the query results that is not on the form?
Thank you for your replies.
Deleting the RecordSource and then replacing it worked. It also explains why I was sometimes able to reference a field in the RecordSource and sometimes unable to reference a field.