Sub Form Display

[judith]

I am opening a popUp form from a record displayed in my main system. The pop
up is based on a query which feeds the key fields from my current record and
so opens the related pop up record. If no record exists the default values of
the key fields are set to the values on the displayed current record. This
all works fine but my pop up has a sub form. It is fine if there is a current
record in the main bit of the pop up but there is a danger that the user will
try to enter info into this part of the form before they enter info into the
main part of the pop up for a new record. Can I keep the visibility off for
this sub form unless or until a record exits in the main pop up form?

Thanks

 

[bhicks11 via AccessMonster.com]

Hi Judith,

You can set the value of the sub-form's visible property in a main form event
where appropriate.

Forms!subformname.visible=true or false

Consider where in your process you need to set it visible and not visible.

Bonnie
http://www.dataplus-svc.com