Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2017
    Posts
    3

    Arrow Data filter on the basis of query to be generated on the Immidate past Coloumn

    Table Co : Having 10 Co ACo B co
    Table Director: have 2-3 different or common director in the said company
    table Meeting : Support i selected company C Meeting while selecting Diretor list must showing only the director in Co not all the director in list as i have already selected the company C
    Thanks
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Really need to give better description of the issue but it sounds like you want cascading (dependent) comboboxes. Common topic. Search web or forum and you will find lots of examples.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Join Date
    Jun 2017
    Posts
    3
    Thanks
    Give me link of some of the example if u do't mind
    thanks once again

  4. #4
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Combobox 1 - companys - row source "SELECT CompanyID, Company FROM tblCos;"
    Combobox 2 - directors - row source "SELECT DirectorID, DirectorName FROM tblDirectors WHERE CompanyID=Forms!formname!combobox1;"
    Combobox 3 - meetings - row source " SELECT MeetingID, Meeting... FROM tblMeetings WHERE CompanyID=Forms!formname!combobox1 AND DirectodID=Forms!formname!combobox2;

    User selects company
    AfterUpdate: Me!combobox2.Requery
    user selects director
    AfterUpdate: Me!combobox3.Requery

  5. #5
    Join Date
    Jun 2017
    Posts
    3
    Thank your Very Much
    www.buchasia.com

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

Similar Threads

  1. Replies: 3
    Last Post: 10-30-2014, 06:24 AM
  2. Replies: 7
    Last Post: 09-19-2014, 07:29 AM
  3. Replies: 4
    Last Post: 10-17-2012, 07:27 AM
  4. Field/coloumn headings in reports
    By Epona in forum Reports
    Replies: 15
    Last Post: 02-09-2012, 10:40 AM
  5. [SOLVED] WHERE statement in lookup coloumn
    By frksdf in forum Queries
    Replies: 3
    Last Post: 01-20-2012, 08:45 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