Clear values in a form.

J

Jeane

I have a form that requests 2 dates (a beginning and then
an ending). It also has another fillable text box. Then
user clicks either "Print" report of these records
or "Preview" in a print preview window these records.

I'd like the user to be able to enter new dates and get a
new range of records. However, it retains the previously
entered dates and text.

What can I do to clear the previous values?

Thanks
 
A

Allen Browne

Set the value of the text boxes to Null:
Me.[StratDate] = Null
Me.[EndDate] = Null
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
Split form 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Clearing Fields in a Word Form 5
Validation in child form 1
Copy previous record into form field 0
How do I clear a form? 0
Clearing form to enter addl info but keep history 2

Top