Run-time Error '2448'

  • Thread starter Thread starter SpecProjAnalyst
  • Start date Start date
S

SpecProjAnalyst

First of all, let me think anyone who is reading this and can provide
assistance.

I am trying to use this in a form to filter the subform. I have a command
button that runs the following code:


' If Assigned To
If Not IsNull(Me.AssignedTo) Then
'Create Predicate
strWhere = strWhere & " AND " & "Issues.Assigned To = " & Me.
AssignedTo & ""
End If

I thought I might need to put brackets around part of the statements but and
getting an "Enter Parameter Value" box when I run the following code:

' If Assigned To
If Not IsNull(Me.AssignedTo) Then
'Create Predicate
strWhere = strWhere & " AND " & "Issues.[Assigned To] = " & Me.
AssignedTo & ""
End If

Any help would be greatly apprecited!!
 
One first step would be to safely initialize the variable strWhere ="".

Try adding a breakpoint and stepping through your code to see the values
assigned to your variables.

Is Me.AssignedTo a numeric or text field? If it's a text field you'll need
to add quotes before and after it in your string like:

strWhere = strWhere & " AND " & "Issues.[Assigned To] = " & """" &
Me.AssignedTo & """"

Ray
 
Back
Top