Very strange problem when hovering a parameter in debug mode

[pess]

I am facing a very strange problem when hovering a parameter in debug mode. I have the following line:
Me.frmJobSub.Form.Filter = "custID=" & customerID
customerID stores the value “1”, see (pic1) attached
I am expecting the result to be:
Me.frmJobSub.Form.Filter = “custID=” 1
Strangely when I hover over the filter parameter I got:
Me.frmJobSub.Form.Filter = "[custID]= 20”, see (pic2) attached
Moreover, in the form side, the code is behaving correctly and filters record “custID=” 1
By the way, the "[custID]= 20” is an old code, written between brackets [custID]. i tried to compact and repair the database, delete the on_load event and recreate it again but with no progress.

 

[bwellbor]

If you simply Step Over that line of code, you'll see that your filter is working properly. My guess is that in your Form Properties, your Filter is set to [CustID] = 20. You can delete that and you won't see that anymore in debug mode. Hope that helps.