Results 1 to 3 of 3
  1. #1
    STarDavos is offline Novice
    Windows 10 Office 365
    Join Date
    Jan 2022
    Location
    Davos, Switzerland
    Posts
    11

    How to sync 2 ComboBoxes?

    My english is not that good AND my Access and VBA knowledge is very limited... so please be patient with me....

    So, here`s my question:

    I would like to synchronise two ComboBoxes, so that the choice in the second box is limited through the choice in the first box.



    'cboKonto': lets me choose from 'tblKonto', containing: 'IDKonto' (Account ID-AutoFill)/ 'Kontonummer' (Account Number)/ 'Kostenstelle' (Account Name)
    'cboMaschinen' lets me choose from 'tblMaschinen', containing: 'IDMaschinen' (Machine ID-AutoFill)/ 'Marke' (Make)/ 'Modell' (Model)/ 'Typ' (Type)/ 'Standort' (Location)/ 'Nummer' (Number)/ 'KontoID' (Account ID)

    I would like to limit the choice in 'cboMaschinen', to my selection in 'cboKonto'.

    Meaning, that if I select 'Kontonummer' i.e.: 4340 in 'cboKonto', it should only let me choose between the entries in 'cboMaschinen', that have 4340 deposited under 'KontoID' in 'cboMaschinen'

    Is this understandable to anyone?

    Thanks in advance
    Last edited by STarDavos; 01-16-2022 at 07:50 AM. Reason: spelling mistakes

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    It is called Cascading combos.

    Google that phrase.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    there is an example here https://www.access-programmers.co.uk...s-form.275155/

    might do more than you need but you will get the principle

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

Similar Threads

  1. Sync Subforms
    By HotelierDream in forum Forms
    Replies: 6
    Last Post: 12-25-2020, 02:05 PM
  2. Sync Ms access to sql
    By bannumails in forum Access
    Replies: 2
    Last Post: 04-26-2016, 06:35 AM
  3. Replies: 3
    Last Post: 03-31-2016, 12:16 PM
  4. Sync two forms....
    By dennissanford in forum Forms
    Replies: 3
    Last Post: 08-31-2013, 11:33 PM
  5. Db sync in Ms access
    By oly in forum Access
    Replies: 4
    Last Post: 02-23-2013, 10:07 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