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