View Single Post
  #3  
Old April 29th, 2010, 11:50 PM posted to microsoft.public.access.forms
Beetle
external usenet poster
 
Posts: 1,254
Default Clear Unbound Text box used as input parameter to query

Well, Me!ZInputEPI = Null *should* work, but if it's not
you might try following it with a Me.Repaint. You might
also try;

Me!InputEPI = ""
--
_________

Sean Bailey


"Mommybear" wrote:

I've looked at everything I can find, tried all the suggestions but still
can't get this to work. I have a form that opens blank. You input your
parameter into an unbound text box then press a command button that performs
a requery of the database and returns the results in a continuous form. When
the results are returned, the parameter is listed as part of the detail in
the form so I want the parameter box to be cleared out and ready for the next
one.

My command on the Search button looks like this:

Private Sub SearchEPICode_Click()

Me.Requery

End Sub

I've tried adding Me!InputEPI = Null but nothing works. Am I adding it to
the wrong place.