Resetting a Multi Value Control on an Access Form

[CharlesSmith52]

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()

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

Private Sub Clear_Form_Click()

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

[isladogs]

No error message displayed in your post

Just to clarify, is this a multivalue field used in a combobox or a multiselect listbox?
Can you post a screenshot please

[CharlesSmith52]

No error message displayed in your post

Just to clarify, is this a multivalue field used in a combobox or a multiselect listbox?
Can you post a screenshot please

The Error message is as follows: Run-time error 3032: Cannot perform this operation.

The control is a Combo Box with Allow Multiple values set to YES a Row Source (names separated by semi colons and a Row Source Type of Value List.

When you open the control it provides a list of 50 name to select from. The name(s) are selected by putting a tick in the check box next to the name or name(s).

The field that I am have the problem with is "Work Performed By".

Hope this helps

[Missinglinq]

I know jack about MVFs...but the name [Work Performed By] would suggest that you're dealing with a Text field. But

Me![Work Performed By] = False

would suggest that [Work Performed By] is a Yes/No field.

Which is it?

And BTW...Date is a Reserved Word, in Access VBA, and shouldn't be used as a Field name.

Welcome to Access Forums Net!

Linq ;0)>

[Gicu]

See if the solution shown in this thread works for you: https://www.pcreview.co.uk/threads/c...o-box.3945913/

Me.![Work Performed By] = Array()

Cheers,

[isladogs]

Using multivalue fields (MVFs) will cause you a lot of problems and is generally considered to be a bad idea.
I have an article explaining some of the most important issues on my website: Multivalued fields....and why you shouldn't use them

[ssanfu]

In addition to not using reserved words as object names, you should also avoid using spaces in object names (objects include field, table, query, form and report names).

[CharlesSmith52]

Vlad

Thank you for your code it works.

Thank for you assistance to my problem.

Charles

[Gicu]

Charles, my pleasure, glad to hear it works for you and good luck with your project.

Cheers,
Vlad