Clear Unbound Text box used as input parameter to query
in [Form]
|
Prev: Error 94 Invalid Use of Null
Next: Recordsouce question
From: Mommybear on 29 Apr 2010 16:31 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 29 Apr 2010 18:20 On Thu, 29 Apr 2010 13:31:01 -0700, Mommybear <Mommybear(a)discussions.microsoft.com> 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. Probably. You don't say where you're adding it! I presume that the textbox named InputEPI has no Control Source, right? What do you mean by "the parameter is listed as part of the detail"? -- John W. Vinson [MVP]
From: Beetle on 29 Apr 2010 18:50 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.
From: Mommybear on 30 Apr 2010 09:21 That is correct, it does NOT have a control source. The parameter is used to search a field on my query, when it returns, the query field is displayed on my form which happens to be the same as the parameter. "John W. Vinson" wrote: > On Thu, 29 Apr 2010 13:31:01 -0700, Mommybear > <Mommybear(a)discussions.microsoft.com> 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. > > Probably. You don't say where you're adding it! > > I presume that the textbox named InputEPI has no Control Source, right? What > do you mean by "the parameter is listed as part of the detail"? > -- > > John W. Vinson [MVP] > . >
From: Mommybear on 30 Apr 2010 09:25
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. "Beetle" wrote: > 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. |