I have a query which returns a single record based upon using DMax on one field and a lookup value from a form on another.
Run in isolation the query correctly returns a single record but when I try to use the query as a recordset it returns the above error.
The cause of the error is the lookup from the form, if it is replaced by a value then the query can be used without a problem. In all cases the form is open in form view.
The answers I have seen on other websites do not help and I am wondering if anyone has come across this before and could point me in the right direction
Many thanks
Jeff
Run in isolation the query correctly returns a single record but when I try to use the query as a recordset it returns the above error.
The cause of the error is the lookup from the form, if it is replaced by a value then the query can be used without a problem. In all cases the form is open in form view.
The answers I have seen on other websites do not help and I am wondering if anyone has come across this before and could point me in the right direction
Many thanks
Jeff