In the database on Tab B in a subform, all the client sees of the record is the Date field, the label, and the record selector. When the client clicks the record selector (that goes from edit to saved mode) after adding a date in the date field, all is well. But if the client hits the Enter key after typing in the new date, the date disappears and the text box appears to be empty.
- If the Enter Key Behavior property is set to default, the data disappears from the text box and the record selector automatically goes from edit to saved mode. The data appears in the alternate Tab A/subform, but does not appear in the current form until I exit the main form and open it again.
- If the Enter Key Behavior property is set to New Line in Field, the data disappears from the text box and the record selector is still in edit mode. When the record selector is clicked (to save mode), the data reappears in the date field and the record appears in the alternate Tab A/subform.
How do I keep the data from disappearing when the client hits Enter after entering the Date data? Thanks for your advice!
See more about the project below, in case more information is needed.
I'm building a subform In Tab B that contains a record consisting of DateOfService (date), UniqueID (number), ServiceType (text), and SpecialistName (text). The client only needs to see the DateOfService field, so the other fields in the record are set to not visible, and ServiceType and SpecialistName have default values set. What is visible on the subform is the DateOfService field and it's label, and the record selector. When the client adds, updates, or deletes a record, event procs fire and the data is updated/deleted on another tab/subform (Tab A), which contains a different view of additional data from in the table. Then the focus comes back to the original subform. All is working, except I discovered this issue when hitting Enter after adding data in the date field. Using Access 2010.