Results 1 to 2 of 2
  1. #1
    survivo01 is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    71

    Query drop down filter list has data that is not in table.

    Drop down filter list in query has data that when I look in table is not there. However, If I try to filter it wants the data that is not listed. e.g...
    []Mod1
    []Mod1[]


    I have to filter for both to get all Mod1 records but when I look directly in the table there is only Mod1 not Mod1[]Mod1 how come?

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Couldn't possibly say without seeing the row source SQL of the combo box.....

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 11-13-2011, 08:01 AM
  2. Table drop down list filter
    By jbataille86 in forum Access
    Replies: 2
    Last Post: 08-05-2011, 08:37 AM
  3. Replies: 4
    Last Post: 06-16-2011, 09:30 PM
  4. Replies: 2
    Last Post: 02-13-2010, 01:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums