Subforms: this should be easy [RESOLVED]

I'm working with VBA/Access 2000.

I have a frmForm and a frmSubform. The subform is independant, no child link and all. It shows a customer's info (name, adress and so on).

I want the subform to go to a newrecord. I've tried the following "GoToRecord" method, with no succes:

DoCmd.GoToRecord acDataForm, Forms!frmForm.frmSubform.Form.Name, acNewRec

I get the error: "The Object 'frmCustomer' isn't open".

...so it gets the form name alright, but because it's in a subform (?), it says it isn't opened.

Any idea? Thanks

Well, is the form open? Have you loaded it?

Yes it is opened.

The customer's file is all there in the subform... I can even interact with it. I don't know how to reach a "new record".

Keeps on saying the form isn't opened. It is actually opened, but throught the subform - it's the only (and important, it seems) difference.

I solved my problem. VB Help comes in handy sometimes:

Quote:

---

If you leave the objecttype and objectname arguments blank (the default constant, acActiveDataObject, is assumed for objecttype), the active object is assumed.

---

So I replaced:
DoCmd.GoToRecord acDataForm, Forms!frmForm.frmSubform.Form.Name, acNewRec

by:
DoCmd.GoToRecord , , acNewRec

Works good.

Have you ever have code just stop working while dealing with sub forms? I just can't get to the bottom of it.

I'm not using subforms the way it's meant to be used. I simply added a subform control to an old application so I could use a listbar on the left of the main window.

That way, clicking the listbar just selects the form to be displayed in the subform.

I'm playing with 2 subforms, making the navigation real quick from one screen (subform) to another only by playing with the "visible" property.

No problem so far.

I do that too, I have all the navigation on a sub form... it's the bound one's that are Ping about on me... thanks tho'