I used the attach code to do virtually the identical thing with a report. Using a combobox to filter the results of a report, and I'm having no luck transferring the same concept to opening a form rather than a report. The user would choose to enter data on a form, and seperate form with a single combobox would pop up anking for details, which would then filter out the main form.
Code I've been trying to use is below
Private Sub cboChooseOption_AfterUpdate()
On Error GoTo Err_cmdFormApp_click:
FormName = "frmAddDataForOptionChosen"
Wherecondition:="[PK] = '" & Me!cboChooseOption.Column(0) & "'"
If Err.Number = 2501 Then
Else: MsgBox Err.Description