Hi, I was wondering if there is

[paulminne]

Hi,

I was wondering if there is a way to clear the contents of a query from the click event of a button on a form?

Currently I can set a dummy field into the SQL statement which returns no results, and subsequently clears the query, however this isnt really a viable solution.

Thanks,

- Paul

 

[Darrylles]

Hi,

Can you clarify what you want exactly?

Where is the query used? Is it the record source for the form or control on a form?

If it is a query in it's own right i.e. you have a query with a name, then no - you can't 'clear' it - it is an object with it's own value.

Regards,

Darrylle

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk