Good afternoon,
I'm hoping someone can see where I'm going wrong!
I have a form where you can enter criteria into text boxes to search for clients records. The details of the clients records then appear in a subform (subClientSearch) on the form. The subform data is provided from a simple SQL union query which searches against the data in the text boxes. The query is run by clicking on a button which runs the line of code subClientSearch.requery.
The problem is that this works fine the first time you use it when opening the form. However if you use it a second time you get an error message 'object invalid or no longer set'.
Does anyone know where I'm going wrong or how I can avoid this?
Any help greatly appreciated.
Grieg.
I'm hoping someone can see where I'm going wrong!
I have a form where you can enter criteria into text boxes to search for clients records. The details of the clients records then appear in a subform (subClientSearch) on the form. The subform data is provided from a simple SQL union query which searches against the data in the text boxes. The query is run by clicking on a button which runs the line of code subClientSearch.requery.
The problem is that this works fine the first time you use it when opening the form. However if you use it a second time you get an error message 'object invalid or no longer set'.
Does anyone know where I'm going wrong or how I can avoid this?
Any help greatly appreciated.
Grieg.
