My db has 2 fields, First & Last. On a form, I have 3 Text Editor objects. One for First, one for Last, and a third for Name. The text editor objects for First & Last use Field/Variable mode and display the values of those fields. The Name Text Editor object is in Formula mode with the ‘Data:’ being ‘First+" "+Last’ and the Procedure being
First = firstword(TextEditingResult) Last = lastword(TextEditingResult)
On the Data Sheeti, If I enter a new record, the Form does reflect all 3 Text Editor objects with the proper values.
If I edit the Name field on the Form, the First & Last fields do update on both the Form and the Data Seet.
BUT… If I add a new record on the data sheet, and then on the Form, enter ‘Abe Adams’ in the Name Text Editor object, I only get ’ Adams’ in the Name field, and ‘Adams’ in the Last field, but nothing in the First field.