Clearing fields on close

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top