Forms and visibility

P

patrick

How do i make a subform only visible when the contents of
a field on the main form has a valid entry (ie is not
blank).

I do not wish the sub form to be visible at any other
time.


pat
 
R

Rick Brandt

patrick said:
How do i make a subform only visible when the contents of
a field on the main form has a valid entry (ie is not
blank).

I do not wish the sub form to be visible at any other
time.


pat
Click to expand...

Me.SubformControlName.Visible = Not IsNull(Me!FieldName)

You need the code above in the Current event of the main form and in the
AfterUpdate event of the control bound to the field in the expression.
 
J

John Vinson

How do i make a subform only visible when the contents of
a field on the main form has a valid entry (ie is not
blank).

I do not wish the sub form to be visible at any other
time.


pat
Click to expand...

Answered in microsoft.public.access. Please do not multipost: if you
must post to more than one newsgroup, please crosspost by putting all
the relevant newsgroups (no more than three please!) in the Newsgroups
line.

John W. Vinson[MVP]
 
Top