string type mismatch

[trustsun]

Hello everyone, could you help me to revise this string filter code. I'm getting a type mismatch because the values are numbers.

strFilter = strFilter & "[NBR]=" & Nz("'" + Me![cmbme] + "'", "[NBR]")

I need it to filter by number values.

-Thanks

 

[dhookom]

Your objective isn't real clear from your expression. Maybe try something like:
strFilter = strFilter & "[NBR]=" & Nz(Me![cmbme], [NBR])


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[PHV]

Perhaps something like this ?
If IsNumeric(Me![cmbme]) Then
strFilter = strFilter & "[NBR]=" & Me![cmbme]
End If

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886