Using MS Access 07
I have a Form where if the user clicks a control button I have it Open a 2nd form.
On that 2nd Form there are two Unbound combo boxes that the user selects a State or County to filter info on that 2nd form.
That same State and County had already selected on the 1st Form (also in unbound combo boxes) before they clicked on the control button.
The 2nd Form is Not a subform of the 1st. It is an independent form.
On both Forms the Unbound State combo box is named "cboSelectState" and the Unbound County combo box is named "cboSelectCounty"
My OnClick event on the 1st Form is
Private Sub cmdAddStateCountyBkType_Click()
Dim lngState As Long, lngCountyCode As Long
lngState = Me.cboSelectState.Column(0)
lngCountyCode = Me.cboSelectCounty.Column(0)
DoCmd.OpenForm "frmSys_ValidCountyCodeBookType", , "[cboSelectState]=" & lngState & "," & "[cboSelectCounty]=" & lngCountyCode
It opens the Form correctly but it doesn't update those two combo boxes on the 2nd from with the info I'm trying to pass to it.