Unwanted Message box when applying filter 1

[Fr33dan]

Hi. I've been working on a database for awhile now and I have a button on a form that is supposed to apply a filter based on criteria from the user. However when I actually go to apply the filter in the code I get an message asking to input the value for the filter even though I stated it in the code.

FileName = ("AutoNumber=" + numbers)
MsgBox (FileName)
Me.Filter = FileName
Me.FilterOn = True

The message box call is just something I added to debug it. If I type in the value that is returned manually the filter works as it's supposed to. I've also tried using DoCmd.ApplyFilter but i get the same error. Thanks in advance for your help.

 

[PHV]

The underlaying query/table of the form has a numeric field called AutoNumber ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Fr33dan]

Well After reading your post I thought "Thats so simple it just might be the problem". The name of the field in the table is Auto Number not AutoNumber. Thank you very much for helping fix my own stupidity.