How do I hide a subform?

[Stapes]

Hi

I ahev a subform called Vat_Rate which I am trying to hide on
occassions.

I have tried

Me.Vat_Rate.Visible = False

and

Forms![Order Form]![Order Details].Form.[VAT Rate].Visible = False

I keep getting Object doesn't support this property or method.

Stapes

 

[Stapes]

Hi

I ahev a subform called Vat_Rate which I am trying to hide on
occassions.

I have tried

Me.Vat_Rate.Visible = False

and

Forms![Order Form]![Order Details].Form.[VAT Rate].Visible = False

I keep getting Object doesn't support this property or method.

Stapes

Ignore that - bullshit error message from bug ridden access.

 

[Dennis]

Forms![MainFormName]![Vat_Rate].Visible = False

 

[BruceM]

If this code is in the main form's code module, Me.Vat_Rate.Visible = False
should work if Vat_Rate is the name of the subform control. Note that this
is not necessarily the same thing as the name of the subform. Does Vat_Rate
show up as one of the Intellisense choices after you type Me.?

 

[leeling]

Hi

I ahev a subform called Vat_Rate which I am trying to hide on
occassions.

I have tried

Me.Vat_Rate.Visible = False

and

Forms![Order Form]![Order Details].Form.[VAT Rate].Visible = False

I keep getting Object doesn't support this property or method.

Stapes