[AccessD] Question about SubForms

Looks like you want to control this from the subform side, but how about
doing it on open of the main form:

Me.SubForm.Form.FormHeader.Visible = False

Tested this in AccessXP and seems to work.

HTH,
Don

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Tuesday, December 28, 2004 11:46 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Question about SubForms


I have a tabbed form on which each tab contains a subform. One of these 
subforms can also be opened independently. It contains a form header 
which contains a "finder" (i.e. combo-box that does the find-thing). 
When it's opened as an independent form, I want the header to show, but 
when opened as a sub-form I want it to be hidden.

Unsure of the syntax here. My OnOpen code simply says (so far)

If IsSubForm(Me) Then
    ' various failed attempts go here
End If

The function IsOpen() is pretty much standard. Check the form's 
parent.name attribute. But I am unsure how to hide the header given a 
True response from IsSubForm().

TIA,
Arthur



-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.298 / Virus Database: 265.6.5 - Release Date: 12/26/2004

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com