We have a subform that is trying to manipulate the field values on a repeating calendar entry. We’re calling Source.FieldSetText in the subform’s QuerySave event. The values we’re setting are being saved just fine for a single calendar entry, but when it’s a repeating entry, the values that we set are not being saved to the document.
The following simple example will illustrate the problem. Since the subform QuerySave gets called after the form’s querysave, we can duplicate the issue by calling FieldSetText at the very end of the form’s QuerySave event. (This is in the form _Calendar Entry.)
The very last line of the form’s querysave is:
Call csEventObj.QuerySave( Continue)
To reproduce the problem we’re having, simply put a FieldSetText call before this line, and another one right after it. If you then create a single calendar entry, the subject will end up being “123”. If you create a repeating entry, the subject ends up being “abc”. The problem here is that our subform code is also firing after this, so therefore any field values that we set in that code are being ignored.
Does anyone know a workaround for this to get the “123” to save on repeating entries, as well as single?
source.FieldSetText “subject”, “abc”
Call csEventObj.QuerySave( Continue)
source.FieldSetText “subject”, “123”
Msgbox “pause to look at subject value”