Select and Deselect in a sub-form field
I have a script that will update a field in a sub-form here:
Contacts_subform.Event_Role = "Venue Contact"; //(this works)
However this method will remove all other options and only add this option. I want to be able to add a selection with select() and remove just one option with 'deselect()'. by using this:
Contacts_subform.Event_Role.select("Venue Contact"); //(this does not work)
Unfortunately I get the following error:
'Event_Role' does not exist in this form.