Clear Data on Search Form

[gatorcc]

I have created a form that feeds to a query for my users to be able to search by any of three different criteria. What I am looking for is to create a button the user can click to clear the contents of the search and search again without closing the form and then reopening it.
I tried all of these with no luck.
Me.Name = ""
Me.Name = Null
Me.Name.undo

[FrymanSMU]

So are you trying to search the search results? I don't understand why you would not close and reopen. Maybe try vbNullString?

[hansup]

Me.Name = ""
Me.Name = Null
Me.Name.undo
For code used on a form, "Me.Name" refers to the name of the form. If your form contains a control whose name is "Name", give it different name and try your code with the new name.

Good luck,
Hans