christerhaard
Programmer
Hi Gurus,
Description
Form with two subforms the subforms are "A" and "B"
by double_click a field in "A" I want to set focus at subform "B" and search and display the same artikle that I clicked on in "A", yes they are linked to the same database.
This is what I do today, but with this I open a new form:
instead I would like to move to my subform and display the result.
Private Sub ARTIKELID_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "ARTIKLAR"
stLinkCriteria = "[ARTIKELID]=" & Me![ARTIKELID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub
Thanx for all your help!
Description
Form with two subforms the subforms are "A" and "B"
by double_click a field in "A" I want to set focus at subform "B" and search and display the same artikle that I clicked on in "A", yes they are linked to the same database.
This is what I do today, but with this I open a new form:
instead I would like to move to my subform and display the result.
Private Sub ARTIKELID_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "ARTIKLAR"
stLinkCriteria = "[ARTIKELID]=" & Me![ARTIKELID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub
Thanx for all your help!