Results 1 to 3 of 3
  1. #1
    Join Date
    May 2010
    Posts
    67

    Unanswered: DoCmd.OpenForm - FILTER not working consistently

    Hello

    I am executing the following:
    DoCmd.OpenForm "frmDownloadLog", , , "logid = " & Me.LogID

    When the LOGID field is double clicked, the form should open with the appropiate record. Sometimes it does and sometimes it does not. The LOGID does exist and the record has valid data. Would anyone have any idea as to why the form is not consistently displaying the record.

    Thanks so much in advance for you HELP.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Does LogID refers to a numeric column?
    Have a nice day!

  3. #3
    Join Date
    May 2010
    Posts
    67
    Yes it is a numeric column. Someone advised me to set the data entry mode to ACEDIT in the OpenForm command. It is now working GREAT.

    Thanks for responding to my question. I appreciate it.

Posting Permissions

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