如何移动到查询记录结果中的特定记录 [英] How to move to a specific record in a query record result

问题描述

您好，我在点击事件程序中有以下内容：

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.

推荐答案

检查docmd.openform的帮助文件。您的答案在OpenArgs参数的描述中。

Check the help file for docmd.openform. Your answer is in the description of the OpenArgs parameter.

这篇关于如何移动到查询记录结果中的特定记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！