I have a form "frmRequisitions" with unbound controls which is used for data entry.
I've placed a combobox in the form header which I would like to use to filter previously saved records from the "Description" record field, then open that previously saved record on the existing (opened) form.
How might I go about doing this? I've placed the following code in the combo box's After Update event. The form appears to refresh, but it doesn't bring up the selected record based on the Description field.
I've placed a combobox in the form header which I would like to use to filter previously saved records from the "Description" record field, then open that previously saved record on the existing (opened) form.
How might I go about doing this? I've placed the following code in the combo box's After Update event. The form appears to refresh, but it doesn't bring up the selected record based on the Description field.
Code:
DoCmd.OpenForm FormName:="frmRequisitions", WhereCondition:="[Description]=" & Chr(34) & Me.cboBrowse & Chr(34)