Subform Question

[SpiritedAway]

Hi all I'm getting a bit confused with syntax -

I have a [MainForm] with a [SubForm]

I'm trying to get [Button1] to be visible on the [MainForm] when user clicks on a [TextBox] in [SubForm].

Can anyone advise on the code I would use for that?

Thanks

 

[boblarson]

Me.Parent.Button1.Visible = True

The Me.Parent part tells Access you want the parent form of the form the code is on.

 

[spikepl]

Check this : http://access.mvps.org/access/forms/frm0031.htm

 

[SpiritedAway]

Brilliant - thanks boblarson and spikepl.