Close Event, Clear All Fields

[jwood29]

What would the code look like for Form Close event to clear all fields, except my prepopulated today's date field.

Mainly I want my text box Evaluator: to not have persons name from before. And the Employee to be null or blank in the drop down list.

Thanks in advance.

 

[georgedwilkinson]

It doesn't seem relevant, when the form closes, the form can no longer be seen and the form is no longer bound to a record.

What are you trying to do?

 

[jwood29]

I have a form called evaluation:

After I have entered employee, category score, and comments.
I click Save. Then Exit button.

But when I open the form up again.... as user would do the next time.

The employee and category are pre-populated already. I do not want this. I would want the user to open a fresh form with null data, not pre-populate with prior employee in the drop down list.

I think I need to add some code on the Forms Close Event to clear it all, to be null when opened up again.

thanks.

 

[Alc]

If you set the form to open to a new record each time it opens, the fields will be blank.

 

[missinglinq]

In Design View for the form, goto Properties - Data and set the Data Entry property to Yes. WHen the form opens it will have a new record showing with the fields empty, awaiting data.

 

[jwood29]

that was it guys. I set the data entry to yes and defaults to null. Now form opens blank. Thank you.

 

[missinglinq]

Glad we could help!