Subform

[Pass-the-reality]

on frmUpdateRecords, I have a Text0 field. Using the wizard, I added a
button to frmUpdateRecords that will open frmMainForm but ONLY show me the
records within frmMainForm where Text0 on frmUpdateRecords and CSR on
frmMainForm are equal. This code works great. (See below) However, I also
want to say that of those records, I only want to see the records where field
OrderBy on frmOrder is null. frmOrder is a subform on frmMainForms. What do
I need to add?


Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmMainForm"

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