I want to use a cmd button to clear a text box and a combo box on a form. The combo box gets populated by a table, which is produced by a query off of the number entered into the text box. ie;

The user enters a number in the text box and then hits a button to run the query/produce the table to populate the cbo box. Then they choose a date from the cbo box and hit a 2nd cmd button to run the app and produce a spreadsheet.

I'd like to have a clear button to reset all the controls on the form in the event that they close the Excel speadsheet and want to run another number/date sequence.

Do I need to:
Delete the table then run a procedure to clear the 2 form fields?

Thanks

Why do you need to make a table?