Very strange problem when hovering a parameter in debug mode

P

pess

Joined
Aug 12, 2011
Messages
2
Reaction score
0
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.:confused::confused::confused:
 

Attachments

  • pic1.jpg
    pic1.jpg
    125.4 KB · Views: 1,158
  • pic2.jpg
    pic2.jpg
    124.8 KB · Views: 203
B

bwellbor

Joined
Sep 15, 2011
Messages
2
Reaction score
0
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.
 

Attachments

  • Pic1.png
    Pic1.png
    23.9 KB · Views: 288

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access a named parameter in an RDLC report in local mode 1
Strange problem with DEBUG directive 1
very strange proble with access queyr and parameter 2
very strange problem while trying to show multiple images in a report. 5
DataGrid Row selection in a VB Form 5
strange problem with access query and parameter ... 1
Emails seemingly disappearing.. very strange problem 6
A very strange workgroup problem 3

Top