I am having a problem applying a filter of a form using a dropdown with the following code
Private Sub ActionFilter_AfterUpdate()
Dim intActionTypeID As Integer
intActionTypeID = Me.ActionFilter.Column(0)
MsgBox strActionTypeID '(just put this here to check integer is correct)
Me.Filter = "[ActionTypeID] = '" & strActionTypeID & "'"
Me.FilterOn = True
It appears the value (1) is being passed, but I get the message "The search key was not found in any record", so I am assuming the problem is in ... '" & strActionTypeID & "'", but I can't work out what it is. If I use Me.Filter = "[ActionTypeID] = 1" then it works.
Can anyone help before I jump out the Window?