Hi all,
I have a form with a subform.
The subform has combo box filters which I use to filter records on the subform.
However, I want to clear them when the user clicks add new record.
Thus far, I have come up with the following code - but it keeps saying "Object does not support this property or method"
Here is my code
Private Sub addNewRecord_Click()
On Error GoTo Err_addNewRecord_Click
Me![su_file subform].Form.cboBox.RecordSource = " "
DoCmd.GoToRecord , , acNewRec
Exit_addNewRecord_Click:
Exit Sub
Err_addNewRecord_Click:
MsgBox Err.Description
Resume Exit_addNewRecord_Click
End Sub