View Specific Records within a form

[Pass-the-reality]

Using the Wizard, I created a button on my form (frmSearch) that will open my
main form (frmMainForm) and only show me those records where the text2 field
on frmSearch equals the CSR field on frmMain. How do I add to this code (see
below) to then say of those records, only show me the records where both
fields QABy and OrderBy on the frmMainForm are null.

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmMainForm"

stLinkCriteria = "[CSR]=" & "'" & Me![Text2] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

 

[Dale Fye]

Try:

stLinkCriteria = "[CSR]=" & "'" & Me![Text2] & "'" _
& " AND [QABy] IS NULL " _
& " AND [OrderBy] IS NULL"

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.