Open another Database Form on specific record

[jamescullis]

hi all,

I'm wanting to open a record in another database, below is the code that opens the form to the correct record in the DB I want to open.

can anyone shed light on code required to do this please?

Private Sub btnDetail_Click()
    DoCmd.OpenForm "fJob", , , , , , Me.Name
    Forms![fjob]![txtJobNumber] = Forms![fJobAlphabetic]![fJobAlphabeticSub].Form![JobNumber]
End Sub

thx

 

[CJ_London]

The code you want is something like

DoCmd.OpenForm "fjob", , , "myName='" & Me.myName & "'"

You will need to change the bits in red to suit. Note that Name is a reserved word and it's use can have unexpected consequences - for example Me.Name is the name of the form the code is written, not the value in a field on that form.

 

[jamescullis]

thanks Cj, I'll try that.