P
Pass-the-reality
Using the wizard, I created a button on a Form ( frmViewRecords) so that at a
click of the button, I could view only those records where Text0 on
frmViewRecords and CSR of frmMainForm are the same - see code below. I need
to take the code one step further. Within frmMainForm, there is a subform
called frmOrderNumber. How do I also say but show me records were OrderBy on
frmOrderNumber is null?
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmMainForm"
stLinkCriteria = "[CSR]=" & "'" & Me![Text0] & "'" _
DoCmd.OpenForm stDocName, , , stLinkCriteria
click of the button, I could view only those records where Text0 on
frmViewRecords and CSR of frmMainForm are the same - see code below. I need
to take the code one step further. Within frmMainForm, there is a subform
called frmOrderNumber. How do I also say but show me records were OrderBy on
frmOrderNumber is null?
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmMainForm"
stLinkCriteria = "[CSR]=" & "'" & Me![Text0] & "'" _
DoCmd.OpenForm stDocName, , , stLinkCriteria