Removing contents of a table but not the table

  • Thread starter Thread starter Joy
  • Start date Start date
J

Joy

I have a form for change/ update requests. When the user fills in the form,
the data goes into a table. I don't wish for the table to grow as it takes up
weight.
I would like the table's contents to be removed either when users exit from
the application or close the form.

What is the best approach?

Thanks Joy
 
Joy said:
I have a form for change/ update requests. When the user fills in the
form, the data goes into a table. I don't wish for the table to grow
as it takes up weight.
I would like the table's contents to be removed either when users
exit from the application or close the form.

What is the best approach?

Thanks Joy
Click to expand...

Run a delete query against the table either when you close the app or when
you open it.
 
Joy said:
I have a form for change/ update requests. When the user fills in the form,
the data goes into a table. I don't wish for the table to grow as it takes up
weight.
I would like the table's contents to be removed either when users exit from
the application or close the form.

What is the best approach?
Click to expand...

If you don't need to save the data then why not just create a Word form to fill in?

Tom Lake
 
Back
Top