Unwanted Message box when applying filter

[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.

EDIT: I figured out the problem with the help of another forum. My field's name is Auto Number not AutoNumber. Thanks anyway.

[NeoPa]

Thanks for the update. It always helps to know :)

Welcome to Bytes!