form visible if parent has record

[deb]

I have a form called fTLNo with autonumber id called TLNoID
and a subform called f001WithinS with autonumber id called WSID.

I only want the subform to be visible if the parent form TLNoID has a
record. (not showing autonumber as the ID).

Please help, thanks!!

 

[Ken Sheridan]

Deb:

In the parent form's Current event procedure put:

Me.f001WithinS.Visible = Not Me.NewRecord

This assumes that f001WithinS is the name of the subform control, i.e. the
control in the parent form's Controls collection which houses the subform,
not the name of the underlying form object (unless both have the same name of
course).

To make the subform visible once you start to add a new record in the parent
form put the following in the parent form's BeforeInsert event procedure:

Me.f001WithinS.Visible = True

Ken Sheridan
Stafford, England