powerboy2988
سه شنبه 02 بهمن 1386, 12:44 عصر
چی جوی می شه تو دستور زیر 2تا stLinkCriteria و stLinkCriteria2 را با همOr و یا And کرد؟
On Error GoTo Err_Command96_Click
Dim stDocName As String
Dim stLinkCriteria, stLinkCriteria2 As String
stDocName = "Form Family"
stLinkCriteria = "[name]=" & "'" & Me![name] & "'"
stLinkCriteria2 = "[family]=" & "'" & Me![family] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.OpenForm stDocName, , , stLinkCriteria2
Exit_Command96_Click:
Exit Sub
Err_Command96_Click:
MsgBox Err.Description
Resume Exit_Command96_Click
از دستور زیر هم استفاده کردم ولی جواب نداد
stLinkCriteria = "[name]=" & "'" & Me![name] & "' And [family]=" & "'" & Me![family] & "'"
On Error GoTo Err_Command96_Click
Dim stDocName As String
Dim stLinkCriteria, stLinkCriteria2 As String
stDocName = "Form Family"
stLinkCriteria = "[name]=" & "'" & Me![name] & "'"
stLinkCriteria2 = "[family]=" & "'" & Me![family] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.OpenForm stDocName, , , stLinkCriteria2
Exit_Command96_Click:
Exit Sub
Err_Command96_Click:
MsgBox Err.Description
Resume Exit_Command96_Click
از دستور زیر هم استفاده کردم ولی جواب نداد
stLinkCriteria = "[name]=" & "'" & Me![name] & "' And [family]=" & "'" & Me![family] & "'"