Clearing fields on close

[Neil Cash]

How can I clear fields within a record on the close event? The fields are
changed consistently and prefilled in the form's on open event depending on
another form. This is just for print purposes, so nothing needs to be stored
in those fields. If this isn't the best way (Access won't let me assign
values, i.e. Null, to the fields when closing), what about overwriting the
fields at the beginning? I know the best way to do this is through a report,
but my client doesn't want it that way, any ideas?

Thanks in advance
Neil Cash

 

[Shaun Beane]

If you don't need to store the data anywhere, why not make all the controls
unbound? Then they will clear out, by nature of being unbound, anytime the
form is closed.

 

[Neil Cash]

Thanks, I didn't realize it was so simple. It works exactly how I want it to.