Prev: Error 94 Invalid Use of Null
Next: Recordsouce question
From: John W. Vinson on 1 May 2010 21:17
On Fri, 30 Apr 2010 06:25:01 -0700, Mommybear
<Mommybear(a)discussions.microsoft.com> wrote:

>None of these worked. I just want to clarify that I'm putting these on the
>command button. Is that where I'm suppose to do this or should it be
>someplace else.
>

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

John W. Vinson [MVP]
From: Mommybear on 10 May 2010 11:41
I still can not get this working, can someone please help.

"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.
From: John W. Vinson on 10 May 2010 13:03
On Mon, 10 May 2010 08:41:02 -0700, Mommybear
<Mommybear(a)discussions.microsoft.com> 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]
From: Mommybear on 10 May 2010 15:10
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
> <Mommybear(a)discussions.microsoft.com> 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]
> .
>
From: John W. Vinson on 10 May 2010 18:33
On Mon, 10 May 2010 12:10:01 -0700, Mommybear
<Mommybear(a)discussions.microsoft.com> wrote:

>John, I thought I answered your question.

The Microsoft website has been losing a lot of posts... sorry for the lame
attempt at humor; I should have realized it was the web interface messing up
again!

>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

And it's not making InputEPI go blank? That's odd. Try adding a line

Me.Repaint

after the =Null line.
--

John W. Vinson [MVP]

First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Error 94 Invalid Use of Null
Next: Recordsouce question