Clearing a Form

[dabatman]

I'm trying to clear data that is bound to a table and a query in my form.



Scenario: In my form I display a table where user can past item numbers into, click get item info button and the results display in a query that's also displayed on the form.

I need the button to clear the table and query. How would I accomplish this?

[June7]

Clearing a table means deleting records. Why would you want to do that? If form is bound to table then move to new record for an 'empty' form.

Show the code for button click event.

[dabatman]

It's a table that I created just to feed the query. Table is displayed in the form as shown below. User has ability to paste item numbers into the table, click Get Items which feeds the query on the right. I'm looking for a way to reset the information in the form.

[June7]

Don't understand 'feed the query'. What purpose does that serve? You print report then want to wipe out the data?

Can delete all records from a table with:
CurrentDb.Execute "DELETE FROM tablename"

Then refresh the form with:
Me.Requery

[dabatman]

Don't understand 'feed the query'. What purpose does that serve? You print report then want to wipe out the data?

Think I got it... Access 2007 behaves stragely at times as I did this yesterday with uneffective results.

Today, I did it and wha-la, it works.

Solutions:
Created a delete query to erase the table.
Created a macro that OpensQuery (the delete query), SelectObject (my form), and then Requery (Control Name of table in form).

When the Rest button is clicked it runs the above macro which clears out the table for my user so they can paste a fresh set up items numbers in.

This is just a tool that allows my users to enter item numbers into the form to pull up their cross referenced item to help my user quickly figure out which items would present the best cost.