B
BMaerhofer
I have a form with a button to show only active records (without a closed
date or reported date). I need for it to show only the records that
Act_Complete is null and Reported_Date is null. I have tried many different
types of VBA and had had no luck:
'Me.Filter = "Act_Complete is null"
'Me.FilterOn = True
'Me.Filter = "Reported_Date is null"
'Me.FilterOn = True
- This will apply the first filter, then the second, but then show the
Act_Complete records that has a value like it removed the first criteria.
I have tried this: 'Me.Filter = "Act_Complete = """ & Me.Reported_Date =
""" "
I just need to be able for it to exclude the records that have a date value
in either the Act_Complete or the Reported_Date field.
Please Help!
Thank you!
date or reported date). I need for it to show only the records that
Act_Complete is null and Reported_Date is null. I have tried many different
types of VBA and had had no luck:
'Me.Filter = "Act_Complete is null"
'Me.FilterOn = True
'Me.Filter = "Reported_Date is null"
'Me.FilterOn = True
- This will apply the first filter, then the second, but then show the
Act_Complete records that has a value like it removed the first criteria.
I have tried this: 'Me.Filter = "Act_Complete = """ & Me.Reported_Date =
""" "
I just need to be able for it to exclude the records that have a date value
in either the Act_Complete or the Reported_Date field.
Please Help!
Thank you!