Form / Subform

[scouser]

Hi guys. I have a menu 'frmMenu' with a subform 'frmMenuSubform'.

'frmMenu' has number of buttons that when clicked display related data in 'frmMenuSubform'.

i.e. If you select Input Form button the subform displays all Forms that allow for data input.

Currently when for frmMenu opens the subform displays all records for all buttons. I would like the subform to either display data for one of the buttons only or to display no data until a button is selected.

Advice as always very much appreciated.
Phil.

 

[boblarson]

Probably the easiest method is to just set the subform's visible property to false until a selection is made.

 

[scouser]

Thanks

Thanks Bob, that worked a treat.
Phil.