Hide calculated control on Form

[solfane]

Hi, this is probably very simple, but I cant get it right....

I have a form with a subform.

The mainform has an unbound ComboBox that references a query.

When a value from this Combo Box is selected, detailed information applies to the subform.

That all works well, but...

There are some unbound controls on the mainform that get info from the subform, and some of these controls are used in calculations.

What I need to do is hide one of these calculated controls on my mainform until a selection has been made from the unbound Combo Box mentioned above.

The reason is that: until something is selected from the unbound Combo Box, the subform is empty, and the calculated controls that are based on the information in the subform show "Error#" until there is data in the subform.

Thanx for any replies.

JAmes

 

[dynamictiger]

Try Me.(subformName).visble=False in the oncurrent event of the form.

In the onchange event of the combobox, make the subform visible property = true

 

[Rich]

Or you could use this method
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=30242