Hi all
I have a form that allows the users to build a query, allowing up to 6 fields. I have another form that will display the results. My problem is it all works except i cannot get rid of the query datasheet with results. I have tried this code in a multitude of places
docmd.close acquery ("Dynamic_Query")
i would have thought that this in atleast the Form_CLose would have worked no dice.
Am i missing something or is the code above incorrect? any help would be appreciated
Raven
I have a form that allows the users to build a query, allowing up to 6 fields. I have another form that will display the results. My problem is it all works except i cannot get rid of the query datasheet with results. I have tried this code in a multitude of places
docmd.close acquery ("Dynamic_Query")
i would have thought that this in atleast the Form_CLose would have worked no dice.
Am i missing something or is the code above incorrect? any help would be appreciated
Raven