Hi. I ran into a weird difficulty the other day. I was trying to open a form from another form and move to the new record IN THE SUBFORM! I was never able to do it!

I've been programming forms for a few years with VBA but I never encountered this one! I am opening the form from a command button in another form and it is supposed to move to the new record in the subform right away but (and it makes sense) it moves to the new record in the main form. When I try to refer to the subform after the OpenForm method I am always told that the form is not open thus I cannot move to the new record.

I solved my problem by making the subform's DataEntry property to True but I loose sight of the other records in the subform.

Any ideas anyone???

Daniel

Daniel

__________________
Daniel

Hi Daniel,

Private Sub Form_Load()
    Me.YourSubFormName.SetFocus
    DoCmd.RunCommand acCmdRecordsGoToNew
End Sub


HTH,

Bob

Humm Bob, thank you very much for the simplest answer I could dream of. I had not even think about the RunCommand method. Funny coz I do used it to save a record and other useful thing.

I really appreciate that you spent a few minutes answering this one.

Daniel

Here's the somple code that I can now use:

Private Sub Form_Load()
    If Me.OpenArgs = "NewEntry" Then
        Me.sforTesting.SetFocus
        DoCmd.RunCommand acCmdRecordsGoToNew
        DoCmd.GoToControl "FinDetailMontant"
    End If
End Sub



Daniel

Glad to help Daniel. Can't count the number I've times I've spent hours and lines of code on a problem, only to have someone hand me the saving two-liner.

Best,

Bob :)