DoCmd.Applyfilter

[Robert_5032]

I cant get my filter to work with variables
Its working fine if I "hardcode" the issueType I want to filter on.

Works fine:
DoCmd.ApplyFilter , "issueType = 1"

Works NOT:
DoCmd.ApplyFilter , "issueType = currentType"

where currentType is a variable with the number of my type of issue.
A messagebox tell me that currentIssue really hold the right value...
Di I need to have any more symbols around a variable name?

Thankyou for any help!
(Im a new Access user and I really love Access!)

Robert

[Salad]

Ro*********@yahoo.com wrote:

I cant get my filter to work with variables
Its working fine if I "hardcode" the issueType I want to filter on.

Works fine:
DoCmd.ApplyFilter , "issueType = 1"

Works NOT:
DoCmd.ApplyFilter , "issueType = currentType"
DoCmd.ApplyFilter , "issueType = " & currentType
should work.

where currentType is a variable with the number of my type of issue.
A messagebox tell me that currentIssue really hold the right value...
Di I need to have any more symbols around a variable name?

Thankyou for any help!
(Im a new Access user and I really love Access!)

Robert

[Robert_5032]

Salad
It worked like a dream!
(I will NOT tell hove many ours I have spent on this...)
Thanks again!
Robert

[Salad]

Ro*********@yahoo.com wrote:

Salad
It worked like a dream!
(I will NOT tell hove many ours I have spent on this...)
Thanks again!
Robert

That's funny. It's happened to all of us where we get so involved that
we see the forest but not the trees.

One other thing. I've never used ApplyFilter. No reason why I haven't
except that I use another method that works fine too.

I may have a series of combo boxes that will create a filter. And I'll
call a routine to build the filter based on entries/selections made. Ex:
Dim strFilter As String
strFilter = "ActiveEmployee = " & Me.ComboActive
If Not IsNull(Me.City) Then
strFilter = strFilter & " And City = '" & Me.City & "'"
endif

Then I enter
Me.Filter = strFilter
Me.FilterOn = (strFilter > "")

So...I like setting Me.Filter and Me.FilterOn.