How to clear form?

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

Guest

I have a need to clear all the fields on a form
when users run query using Record -> Filter By Form
or Filter by Selection menu options.

How can I do so?

'cause otherwise it retains previous values and
sometimes users forget to clear all fields as a result
they run into problem.

Thank you very much!
-Me
 
hi,
In most of my apps, i usually have a clear form sub that
clears forms for the next record or when finished or oops!
startover. (using unbound forms)
I have attached it to a button on some forms and have use
the call command to do it with code. all it does is clear
out all the text boxes.
Sub clearform _click()
me!txtfield1 = null
me!txtfield2 = null
me!txtfield3 = null
ect.ect.ect
cmdAccept.enabled = false
me.txtfield1.setfocus
end sub
 
Back
Top