Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2011
    Posts
    3

    Angry Unanswered: Very strange problem when hovering a parameter in debug mode

    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.
    Attached Thumbnails Attached Thumbnails pic1.jpg   pic2.jpg  

  2. #2
    Join Date
    Aug 2011
    Posts
    3

    problem solved

    problem solved - my bad

    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •