Subform error

[Middlemarch]

 DoCmd.OpenForm "frmIE", acNormal
        With Me.frmPending.Form
            .RecordSource = "tblPending"

Goes to error no matter what I try.


frmIE is a popup modal form and frmPending is a datasheet form I dragged onto it.
What is the correct syntax for the 2nd line please ?

[Edgar]

Are you sure frmPending is the name of the subform control that is housing frmPending?

[Micron]

To know the solution would require that we know the name of the subform control as already suggested. The syntax for drilling down to a control on a subform is
[Forms]![Main form name]![subform control name].[Form]![control name on subform]

You don't need the brackets unless an object name contains spaces. If you don't want to drill down to a control, then truncate that which you don't need from the example syntax.
You might need to put the main form in design view to get the subform control name. Sometimes it is the same name as the subform; especially if you let Access do this for you. Sometimes it is Child0 (or some other number). Figure that out and you should be ok.

EDIT - whenever Access gives an object a meaningless name I always change it to something meaningful if I'm not just playing around.

[Middlemarch]

I've never sure about anything but managed to fluke it with this. After a long time!

DoCmd.OpenForm "frmIE", acNormal
Forms!frmIE.Caption = "This is the caption"
With Forms!frmIE!frmPending.Form
.RecordSource = "tblPending"

[Middlemarch]

Thanks Micron, I'll print that out. Everytime I need to do this I go round the twist.
What actually *is* the subform control. Is it the subform itself ?

[Micron]

The subform is just a regular form in terms of designing one. The subform control is the container (control) that houses/contains the subform. You can select the container by clicking on the thin border that surrounds the subform in design view and seeing what name is displayed in the property sheet. The control type is also shown there (IIRC near the top left of the property sheet).
This might prove useful
http://access.mvps.org/access/forms/frm0031.htm

[Edgar]

This could have worked fine:

With Form_frmPending.Form
.Recourdsource = "tblPending"

Just make sure the form is open, otherwise this will open it for you. Also make sure frmPending isn't being used somewhere else.

[Middlemarch]

Think I got it. Form is the Form and container/control is the Form on it's Parent Form.
Thanks for the link.. sure it a lot of ways to do things.
Edgar, that worked too, I've changed to it.
Thanks for the replies.

[ArviLaanemets]

Subform is really not a form object, it is a container object (more like tab control), which has a form object as source.

Open your main form in design view, and click on subform there ONCE! Look at properties - they are for subform control.
Now click on same subform 2nd time (or double-click at start)! Look at properties again - they are for form contained in subform, and the set of available properties is entirely different from ones displayed for subform.

I always rename the subform control after creating it. When the form contained in it has name fSomeName, then I rename the subform as sfSomeName

[Micron]

Subform is really not a form object,

I prefer to distinguish between the control and the form that it contains by calling one the subform control and the other the subform. True, "subform" is the official name of the control, but then Access isn't perfect is it?