cmbRegions.RowSource = SELECT ID, Region FROM tblRegions
cmbCountry.RowSource = SELECT ID, Country FROM tblCountries WHERE RegionID = frmForm!cmbRegion
cmbPort.RowSource = SELECT ID, Port FROM tblPorts WHERE PortID = frmForm!cmbPort
In the AfterUpdate
event of `cmbRegions':
cmbCountry.Requery
In the AfterUpdate
event of `cmbCountry':
cmbPort.Requery
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…