I'm trying to open a form (frmMainActionLog) via an afterupdate event on a combobox listing investigators. I want to open it with a filter active on open, where the results are limited to the investigator in question.
Private Sub cboInvestigator_AfterUpdate()
DoCmd.OpenForm "frmMainActionLog", , , "[Investigator] = '" & [cboInvestigator] & "'"
In the data, "Investigator" is the name of a field, and cboInvestigator is the name of the combobox on the first form.
It's opening the form, but with no results when there should be.
Any pointers please guys?