John, I thought I answered your question. I'm adding this code on the Search
command button, not the unbound text box. My unbound text box is "InputEPI"
and my search button is "SearchEPICode". This is what my command button
looks like:

Private Sub SearchEPICode_Click()

Me.Requery
Me.InputEPI = Null

End Sub



"John W. Vinson" wrote:

On Mon, 10 May 2010 08:41:02 -0700, Mommybear
wrote:

I still can not get this working, can someone please help.


"Doctor, I don't feel good, what should I take?"

As I asked on the 1st (and got no answer):

Please post your code and the names of the relevant controls.
--

John W. Vinson [MVP]
.