View Specific Records within a form

  • Thread starter Thread starter Pass-the-reality
  • Start date Start date
P

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
 
Try:

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

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.
 
Back
Top