Clearing table when form opens

[MoeIndustries]

Hello, I have a query of payment runs made. I want people to be able to enter 1 or more payment references so the query only shows those payments.



I've created a table that will filter the query once references are entered into it.

What I want now is to create a form so other uses simply enter x amount of references (no limit) into the form and press run for the query to pop open. However, I also want, whenever the form is opened for the table it feeds into to be cleared.

I've tried a delete query but when I open the form it has #deleted in each of the fields.

Hope this is making sense - any help???

[pbaldy]

Sounds like you need to requery the form after running the query. Alternatively you could run the query before opening it.

[MoeIndustries]

Thank you Paul. Could you explain a bit more? At the moment, in the form I have a macro that runs a delete query on the table when the form is opened. I put a requery macro after that but it says 'Requery macro is not available'.

Thanks again.

[pbaldy]

I don't use macros so not sure what you've got. Simplest may be running your query in the open event of the form, if you have it later than that.