Results 1 to 2 of 2
  1. #1
    bdaun is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2010
    Posts
    2

    Combo box values in filter by form w Split DB


    In an "un-split" database, when I do a filter by form I can see the combo box values that are defined for a field (they come from a table/query lookup). However, my production setup is split and when I go to filter by form, I only get the "Is Null, Is Not Null" options in the combo box drop down. Is there a way to change this?
    Thanks!

  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    When you split the database, reset the combo box control source property to the back end table name.

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

Similar Threads

  1. Replies: 8
    Last Post: 02-19-2012, 03:48 PM
  2. Filter my form from combo box
    By Angate in forum Forms
    Replies: 3
    Last Post: 04-24-2010, 01:57 PM
  3. Replies: 1
    Last Post: 03-27-2010, 06:13 AM
  4. filter form based on combo box
    By lloyddobler in forum Forms
    Replies: 8
    Last Post: 09-10-2009, 07:33 AM
  5. Filter Form records with Combo Box????
    By jgelpi in forum Forms
    Replies: 0
    Last Post: 05-19-2009, 07:05 AM

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