Load form from datasheet and set focus

[Dulanic]

Hello,



I am trying to load a double clicked record within a datasheet on the form. I am using the following to load the record:

Private Sub assoc_name_DblClick(Cancel As Integer)
    Dim stDocName As String
    Dim stLinkCriteria As String
    stDocName = "frm_error_entry"
    stLinkCriteria = "[ID]=" & Me![ID]
    DoCmd.OpenForm stDocName, , , stLinkCriteria
    Forms![frm_error_entry].SetFocus
End Sub

This is kind of funky... sometimes when I double click the record it loads the form blank on a new record instead of allowing us to edit the matching record in the original entry form. The other issue is, the .setfocus is acting up too... the form gets loaded but then it goes back to the form the record was double clicked on instead of stating focus on frm_error_entry. Is there a better way to take care of this? I verified there is no code on load/focus etc that would be throwing focus back to the original form.

Any ideas?

[RuralGuy]

Use the acDialog argument to hold the focus on the next form until it is closed or hidden

[Dulanic]

Sorry for not ever closing or replying to this thread until now. I did try that and it still did not work, it would open the window behind the datasheet/form that I was double clicking to open the record.

[RuralGuy]

If you are using the acDialog argument then you could set the Visible property to False before opening the next form and back to True as the next line after opening the 2nd Form.