问题描述
您好，我在点击事件程序中有以下内容：
Hello, I have the following on click event procedure:
Private Sub TextBoxNALCMBRID_Click（）
Dim strForm As String
Dim strWhere As String
strForm =" Branch 142 Membership"
Dim stDocName As String
Dim stLinkCriteria As String
stDocName =" Branch 142 Membership"
stLinkCriteria =" [tblMembers.NALCMBRID] =" &安培;我！[NALCMBRID]
strWhere =" [NALCMBRID] ='" &安培; [NALCMBRID]& "'"
'DoCmd.OpenForm stDocName ,,, stLinkCriteria
'DoCmd.OpenForm" Branch 142 Membership"，WhereCondition：=" tblMembers.NALCMBRID = " &安培; Me.NALCMBRID
DoCmd.OpenForm strForm ,,, acFormEdit
End Sub
Private Sub TextBoxNALCMBRID_Click()
Dim strForm As String
Dim strWhere As String
strForm = "Branch 142 Membership"
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Branch 142 Membership"
stLinkCriteria = "[tblMembers.NALCMBRID]=" & Me![NALCMBRID]
strWhere = "[NALCMBRID] = '" & [NALCMBRID] & "'"
'DoCmd.OpenForm stDocName, , , stLinkCriteria
'DoCmd.OpenForm "Branch 142 Membership", WhereCondition:="tblMembers.NALCMBRID=" & Me.NALCMBRID
DoCmd.OpenForm strForm, , , acFormEdit
End Sub
我想去具体的 Branch 142 Membership 。
I want to go to the specific NALCMBRID when I select it in a split form. The above code is taking me to the first record in the tblMembers for form:Branch 142 Membership.
推荐答案
这篇关于如何移动到查询记录结果中的特定记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！