You have two ways to code in Access - macros and VBA. With rare exception, I use only VBA. I don't think macro can accomplish this particular procedure. Here is an example of a Select Case setting properties of a combobox based on selection of first combobox.
Code:
Sub cboFirstCombo_AfterUpdate()
Select Case Me.cboFirstCombo
Case ""
Me.cboSecondCombo.Value = Null
Me.cboSecondCombo.RowSourceType = ""
Me.cboSecondCombo.RowSource = ""
Case "State Number"
Me.cboSecondCombo.RowSourceType = "Table/Query"
Me.cboSecondCombo.RowSource = "SELECT DISTINCT StateNum FROM Submit;"
Case "Sample Type"
Me.cboSecondCombo.RowSourceType = "Value List"
Me.cboSecondCombo.RowSource = "Acceptance;Independent Assurance;Information;Preconstruction;Quality"
End Select
End Sub