Results 1 to 3 of 3
  1. #1
    skiptotheend is offline Novice
    Windows Vista Access 2007
    Join Date
    Oct 2009
    Posts
    3

    Smile Cascading Combo Box Problem


    Hi there

    Wonder if anyone can help me?

    I have 2 combo boxes (cboCompanyName) & (cboDate) working as cascading combo boxes to filter a query. I have it so that when a selection is made in (cboCompanyName) the relivant dates populate (cboDate). Now I want it to also work the other way round....i.e. when a selection is made in (cboDate) the relivant Company Names are populated in (cboCompanyNames)

    Also, is there a way I can have it that when no selections are made in either combo boxes the query will show ALL records. Then if a selection is made in (cboCompanyName) and not in (cboDate) the query will show All records for that Company. And finally if a selection is made in (cboDate) and not in (cboCompanyName) the query will show ALL records for that Date

    Thank you very much in advance

  2. #2
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    It all depends on how you are processing the filter and applying the filter to the query. If you are referring to the forms directly from the query then it becomes more difficult. If you are building an sql statement then this simplifies the matter somewhat.

    Which method are you using?

    David

  3. #3
    skiptotheend is offline Novice
    Windows Vista Access 2007
    Join Date
    Oct 2009
    Posts
    3
    Hi David

    Thank you for you reply

    At the moment I'm working from the query as I'm a bit inexperienced with SQL but am willing to look at other options with a bit of guidence

    Thanks again

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

Similar Threads

  1. cascading combo
    By rexb in forum Forms
    Replies: 9
    Last Post: 10-26-2009, 04:10 PM
  2. Cascading Combo Boxes
    By desireemm1 in forum Programming
    Replies: 1
    Last Post: 10-05-2009, 06:00 AM
  3. Problem with Cascading Combo Boxes
    By CushingMT in forum Forms
    Replies: 0
    Last Post: 11-13-2008, 09:44 AM
  4. cascading combo form
    By tonysomerset in forum Forms
    Replies: 0
    Last Post: 08-27-2008, 02:10 AM
  5. Cascading Combo Box
    By nywi6100 in forum Forms
    Replies: 0
    Last Post: 10-23-2006, 01:45 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