I have an unbound form on which there are 3 controls: option group, combo box and a subform. The value of the combo box depends on the value of the option group and the value of link child field depends on the value of the combo box. here is the code:
Code:
Dim stSQL As String, stCriteria As String, stDocNo As String stDocNo = Me.cboDocNo If Frame4.Value = 1 Then stSQL = "SELECT