Hi,
I have a form and I set the record souce for this form based on a query built by users (they select different options).
I open the form and then assign the form's record source to the SQL query.
This works fine 90% of the time, however, sometimes instead of displaying the query results it displays "#NAME" in all of the fields in the search results form. When the user then clicks on search again it works fine.
Does anyone know why this might be happening?
It seems a bit quirky because it only happens sometimes.
Any ideas or suggestions appreciated
Thanks
I have a form and I set the record souce for this form based on a query built by users (they select different options).
I open the form and then assign the form's record source to the SQL query.
This works fine 90% of the time, however, sometimes instead of displaying the query results it displays "#NAME" in all of the fields in the search results form. When the user then clicks on search again it works fine.
Does anyone know why this might be happening?
It seems a bit quirky because it only happens sometimes.
Any ideas or suggestions appreciated
Thanks
