How to create a button to clear a subform from a main form

[Fspinelli]

I have a query by form set up.

I coded and can get the fields on the form to clear by the click of a button, but how do I make the subform clear, too?

The main form has a "Clear" button and in the "event procedure" I placed the following code:

Private Sub cmdClear_Click()

    Me.txtFname = Null
    Me.txtLname = Null
    Me.cboCountry = Null
    Me.cboDistribution = Null
    Me.cboPlatform = Null
    Me.cboState = Null
    Me.cboStatus = Null
    Me.cboType = Null

End Sub

When the button is clicked, all of the criteria fields clear but I am not sure how to make it so the subform with the results below it clear, too.

I would greatly appreciate assistance.

Thank you.

[Jerry Maiapu]

The format to access a particula field in a subform from main/parent form is

Forms!MainFormName!Subformname!Subform_Textbox_name

so try something like

Forms!MainForm [B]Name[/B]!Subform [B]Name[/B]!Subform_Textbox_[B]name1[/B]=Null
Forms!MainFormName!Subformname!Subform_Textbox_name2=Null

or else try this format.

me!Subformname!Subform_Textbox_name

[munkee]

i just use

Me.subfrmcontrolname.form.controlonsubfrm = ""

Where subfrmcontrolna me is the name of your subform on your main form. Not the name of the actual subform as per your convention on your database window.

The control name of the subform can differ to the actual form loaded within it.

[Fspinelli]

Thank you very much for your help.

However, I found I could clear the form by simply placing

Me.CONTROLNAME = Null
(etc, if more)
Me.frmNAMEOFSubform.Requery

So once you hit "clear", it requeries based on nothing and produces nothing, clearing the subform.

I don't know if this is the correct way, but it produced nice results for me.

I greatly appreciate your guidance.

[NeoPa]

If that's what you're trying to do, then that's the correct way. Unfortunately your question gave no clue that you desired that effect. In fact it gave an example that implied otherwise. We can only answer your question if you ask it properly.

[Fspinelli]

Can't read a woman's mind? Just kidding...

I see, thank you NeoPa, I will consider that in the future.

I was just not sure how to ask it I suppose. But utilizing other's advise helped me learn a few more things and I really appreciate that.

Have a very pleasant weekend.

[NeoPa]

FSpinelli:
Can't read a woman's mind?

I expect that's it :D

Of course I do realise expressing one's question clearly can be difficult (If I didn't realise that by now I really would be stupid), but I like to bring attention to the importance of it when I get the opportunity.

You'd be surprised how many members don't appreciate that in a forum environment, without all the extra clues you get talking face to face or seeing the project (DB) in front of you, the expression of the question is so much more important.

I know I come off as grumpy sometimes, which is something I can live with if I must, but I'm trying to guide those members to a better way of using the facilities (here and elsewhere of course).

Anyway, have a very pleasant weekend yourself and I'm very glad you managed to resolve your issue :)