multiple link criteria in sql statement

[Lori2836 via AccessMonster.com]

Can you help? The scenario: Click on ID # in a subform and the form opens
with the information tied to the ID, by the Item Desc. What I want to know
is........how do you add to the criteria? I'd like to use Item Desc AND
Customer in the "stLinkCriteria", but not sure how to code it.

Private Sub ID_Click()

On Error GoTo Err_ID_Click

Dim stDocName, stLinkCriteria As String

stLinkCriteria = "[Item Desc]='" & [Item Desc] & "' "

stDocName = "Face Sheet to be reviewed"
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormEdit

Exit_ID_Click:
Exit Sub

Err_ID_Click:
MsgBox Err.Description
Resume Exit_ID_Click
End Sub


Thanks for any help!

 

[kingston via AccessMonster.com]

If I understand you correctly, you just need to extend your existing criteria:


stLinkCriteria = "[Item Desc]='" & [Item Desc] & "' AND [Customer]='" &
[Customer] & "'"

Check for Nulls first in an If statement:

If IsNull([Item Desc]) AND IsNull([Customer]) Then
criteria = nothing
ElseIf IsNull([Item Desc]) Then
criteria = customer-based only
...

Can you help? The scenario: Click on ID # in a subform and the form opens
with the information tied to the ID, by the Item Desc. What I want to know
is........how do you add to the criteria? I'd like to use Item Desc AND
Customer in the "stLinkCriteria", but not sure how to code it.

Private Sub ID_Click()

On Error GoTo Err_ID_Click

Dim stDocName, stLinkCriteria As String

stLinkCriteria = "[Item Desc]='" & [Item Desc] & "' "

stDocName = "Face Sheet to be reviewed"
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormEdit

Exit_ID_Click:
Exit Sub

Err_ID_Click:
MsgBox Err.Description
Resume Exit_ID_Click
End Sub

Thanks for any help!