Clear contents of texbox in Subform from Main form (1 Viewer)

[JPR]

Hello,

I have a main form with two cmd buttons. The first cmdbutton opens a subform on which there is a textbox that I use as a query criteria. Results are displays in a listbox always on the Subform.

On the main form, I also have a second cmd button that should clear the contents of the textbox on teh Subform so that I can run a new query

This is the code I am using:


Forms!MainForm!Subform!textbox = Null

Thank you

 

[arnelgp]

you add Form object to your code, then requery the subform:

With Forms!MainForm!Subform.Form
    !textbox = Null
    .Requery
End With

 

[bob fitz]

Hello,

I have a main form with two cmd buttons. The first cmdbutton opens a subform on which there is a textbox that I use as a query criteria. Results are displays in a listbox always on the Subform.

On the main form, I also have a second cmd button that should clear the contents of the textbox on teh Subform so that I can run a new query

This is the code I am using:


Forms!MainForm!Subform!textbox = Null

Thank you

You say that the button "opens" a subform but subforms are usually hidden or made visible. If you are actually opening another form then the code required would be something like:

Forms!NameOfForm.textboxName = Null
Forms!NameOfForm.Requery

 

[JPR]

Thank you