S
Slippie
Hi, i've been using vba for quite some time now and i've used filters
lot of times. But now i tried to do the following:
Private Sub grpFilter_AfterUpdate()
If grpFilter = 1 Then
Me.Filter = "Opdracht.OpdrachtAanvaard = 'True'"
Me.FilterOn = True
End If
If grpFilter < 1 Or grpFilter > 1 Then
Me.Filter = ""
Me.FilterOn = False
End If
Exit Sub
End Sub
'Opdracht' is a table which has a field name 'Opdrachtaanvaard', thi
field is true//false. Whenever i click on the radiobuttons in th
grpfilter area i get the following error when i turn on the filter
'error 2001 you canceled last operation'
i really don't see the problem so plz plz help me out if you can
*********************************************************************
Also there's something else, in my forms i sometimes use "UPDATE" o
"INSERT INTO" sql statements and they work fine except for the fac
that when i try to update true//false fields with the value of
variable it never works, it says criteria mismatch etc..
it is possible to use variables (such as strings or integers) in sq
statements? right?
so then that means that maybe it wont work with true//false fields?
i'm so confused right now, plz plz help me =
lot of times. But now i tried to do the following:
Private Sub grpFilter_AfterUpdate()
If grpFilter = 1 Then
Me.Filter = "Opdracht.OpdrachtAanvaard = 'True'"
Me.FilterOn = True
End If
If grpFilter < 1 Or grpFilter > 1 Then
Me.Filter = ""
Me.FilterOn = False
End If
Exit Sub
End Sub
'Opdracht' is a table which has a field name 'Opdrachtaanvaard', thi
field is true//false. Whenever i click on the radiobuttons in th
grpfilter area i get the following error when i turn on the filter
'error 2001 you canceled last operation'
i really don't see the problem so plz plz help me out if you can
*********************************************************************
Also there's something else, in my forms i sometimes use "UPDATE" o
"INSERT INTO" sql statements and they work fine except for the fac
that when i try to update true//false fields with the value of
variable it never works, it says criteria mismatch etc..
it is possible to use variables (such as strings or integers) in sq
statements? right?
so then that means that maybe it wont work with true//false fields?
i'm so confused right now, plz plz help me =