Jump to Record

[control1]

I have tested the following and it works for me
Use this code to open the second form

Private Sub btnSaveOpen_Click()DoCmd.Save
    DoCmd.OpenForm "frmViewIssue", , , , , , Me.ID
End Sub

Put this code in the On Open event of your form called "frmViewIssue"

Private Sub Form_Open(Cancel As Integer)

  If Not IsNull(Me.OpenArgs) Then
       Me.Filter = "[ID] = " & Me.OpenArgs
       Me.FilterOn = True
  End If

End Sub

Thanks for your suggestion Bob. For some very strange reason - this still isn't working. I tried the code that you suggested... and it still opens as a new record... Mind Blown!

Bulzie - I've even changed the Autonumber field and removed the initial formatting "ECC1" - deleted all records (they are only test ones) and tried this again. Still, no joy.

Would anyone be able to help if I shared the database? Can I send this via private message (don't really want it public)

Cheers,



Leigh

[control1]

Just thought I should update this thread. I managed to get this working by continuing to fiddle.

I swapped out my DoCmd.Save to

"DoCmd.RunCommand acCmdSaveRecord"

And it works perfectly now.

Cheers,

Leigh