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.

[RuralGuy]

I would try a /decompile : http://www.granite.ab.ca/access/decompile.htm

[pess]

I would try a /decompile : http://www.granite.ab.ca/access/decompile.htm

thanks for your reply
i did decompile, but the problem persist!

[boblarson]

Step PAST that line and then check to see what the filter shows. It has not yet been set and you may have a persistent filter (open the form in design view, and go to the DATA tab and then check the FILTER property and you might see something actually there which matches. Delete it and save the form.

It is possible to get those if the form is saved when the filter has been set. So you want to make sure that there is nothing in that property when saving your form in design view and you do NOT want to have any code anywhere that uses:

DoCmd.Close acForm, "FormNameHere", acSaveYes (or acSavePrompt or blank)

Always use

DoCmd.Close acForm, "FormNameHere", acSaveNo

as acSavePrompt is the default and someone might be able to screw things up by selecting YES to the prompt, thinking it is talking about records instead of DESIGN CHANGES which is what it means.

[pess]

thanks
i like access

[RuralGuy]

Are you ready to use then Thread Tools at the top of the thread to mark this thread as Solved?