Subforms 101

[JFo]

I have just started using my first subform and I cannot seem to apply everything I have learnt up to this time when using the subform and main form



I figure it is the same problem however I am stuck on a number of things such as passing values to other forms, getting combo boxes to work, assigning values and code to the subform, hiding and showing the subform, etc

Previously I have been using code such as

Me.Field1.Visible=True

and

Forms!frmSubForm1.Field1.Visible=True (to other forms or using value from other forms)

however these don't work when using a subform as it cannot find the form any quick advice as I think this may solve many of my subform problems.

I tried making the code public (removing private) but this didn't work

Thanks

[pbaldy]

This should help:

Forms Refer to Form and Subform properties and controls

[JFo]

thanks pbaldy actually on this page at the moment thanks to post before mine have figured out most things now--> 2 that are causing me a bit of trouble are
1) how to use it in an sql query where I would use

WHERE (((tblThis.ThisID)=[forms]![frmSubform1]![cmbThis]))

and

2) how to make the whole subform invisible and then visible

using something like

Me!frmSubform1!Form!Visible = False

from main form

Thanks, this is a great resource

[JFo]

I worked it out I think my subform had the wrong name... idiot

[pbaldy]

Glad you got it sorted out.

[JFo]

Not quite solved how do you write

Forms!Mainform!Subform1.Form!ControlName

as SQL (not VB)

still can't get question 1 to work in normal SQL

Thanks

[pbaldy]

That should work in SQL. The form has to be open, if it isn't.

[JFo]

Thanks, I think my problem is somewhere else