Hi all,

I have a serious problem. I am trying to use the SetFocus method to move the cursor to a subform after I click a checkbox. The code seems pretty straightforward. This is my code:
SuppliesEntry.SetFocus

But for some reason, every time I click on the checkbox to test my code, I get an error that says it can't find the form named SuppliesEntry. Okay, so I go into object browser in the VBE and the form does not appear in there even though all the other forms do. And I know that the form is there because I made the form and I dragged on the other form as a subform. Needless to say I am getting :(. Can anyone please help me?

There is a convoluted naming convention for referring to a subform. It is something like

Forms!MainFormName!SubFormName

You may need to look this up. I had a similar problem and even Alison Balter couldn't help, so I had to abandon the subform. I have seen other posters here post the syntax. Perhaps a search of this forum...

GL

mmcdonal

I beleive that the Forms!MainFormName!SubFormName is due to the fact that Access or VBA creates an instance of that sub-form which is connected to the main form.
If you use Form!SubFormName, that would imply that the sub-form is open on its own (which is possible).

This is the only way I can understand this.

You can create multiple instances of other Forms.
See Access 97 Developers book by Getz, et al.

Hi all,

I figured it out. The syntax is this:
Me.subFormName.SetFocus

And if you want it to be enabled by using a different control:
Me.SubFormName.Visible = Me.chkBoxName

This would be done on the AfterUpdate event for the control. Hope this helps out anyone.

This is probably too late, but the following link SHOULD take you to a form on the AccessWeb where the full syntax of using subforms is tabulated. I have found this invaluable and keep it as hard copy wherever I work.

http://www.mvps.org/access/forms/frm0031.htm

The Article name is 'Forms: Refer to Form and Subform properties and controls' by Keri Hardwicke

HTH