I have an access form that is used for data entry. I have a clear Form button on the form that will clear all controls with the exception of the multi value control that may have upto 4 seperate names contained in the field in the record. The code I am running is:
Private Sub Clear_Form_Click()Code:Private Sub Clear_Form_Click() Me![Date] = Null Me![Job Number] = Null Me![Vehicle] = Null Me![Type of Work] = Null Me![Repair Type] = Null Me![Repairs] = Null Me![Comments] = Null Me![Category] = Null Me![SubCategory] = Null Me![Trip Itinerary] = Null Me![Work Performed By] = False Forms!frmDataEntry!Date.SetFocus End Sub
The error message is
No matter what i try I cannot clear this control and when I close the form in adds a new record with just that field.
Can you please help.
CharlesSmith52