Validation data filtering by fields (1 Viewer)

dim · Jul 20, 2018

Hi

I have a form where I need to verify if two specific fields [Field1] AND [Field2] are filtered.
In the other words I need a code something like:

If me.field1 AND me.field2 are filtered Then
Msgbox "Filter is On"
Else
Msgbox "Filter is Off"
End If

Can you help please?
Thank You!

Ranman256 · Jul 20, 2018

Code:

If not isNull(me.field1) AND not isNull(me.field2) Then
   Me.filter = "[field1]='" & me.field1 & "' and [field2]=" & me.field2
   Me.filterOn=true
Else
     Me.filterOn=false
End if

moke123 · Jul 20, 2018

I think I'm reading the question differently than Ranman.

If you are looking to test whether the form filter is on or off you can test for the filterOn property which will return either true or false.

Code:

msgbox FilterON

If you want to test whether a particular field is included in the filter string you could check if it is included in the string

Code:

If InStr(1, Me.Filter, "YourField") Then
MsgBox "Yes"
Else
MsgBox "No"
End If

HTH

Validation data filtering by fields (1 Viewer)

dim

Registered User.

Ranman256

Well-known member

moke123

AWF VIP

Similar threads

Users who are viewing this thread