I have a form where each day is a unique record or statistical information. The form is bound to a single table with one record per date, no duplicates. For this reason, I put an unbound text box with a short date and used the date picker so that the user can find a record with the calendar.
I am using DoCmd.SearchForRecord to then find the correct record. It finds it and displays the correct record, but then blocks the user from making any edits with the error message "Update or CancelUpdate without AddNew or Edit".
Yet, when the user uses the navigation arrows at the bottom of the screen to locate the record, they can edit it with no problem. In fact, if they use the date picker to find the record, click the navigation button back one record and then forward to the correct record, they can edit it just fine.
I have checked all the form's edit flags before and after the SearchForRecord command and cannot find where anything is getting reset that would prevent an edit.
Anyone ever seen this behavior before?