I have started using text boxes to display information from a combo box query on a split form. The combo box will display (and change) an item number and the text bow will display the item description (can't change) (Attachment 1). It works perfectly (Attachment 2).
However, when I sort the information on the split form by clicking the little triangle at the top of the column I get error message 2759 (attachment 3).
When I click the OK button the sort finishes and the form works fine (attachment 4).
I regularly compact & repair and haven't had anything go wrong. The error message only started showing up when I began using the text boxes. I'm concerned that I'm building an error into my DB and that it will eventually fail. Is this concern valid? Is there a way to avoid the error or fix something so the error doesn't appear?
Attachment 1
Attachment 2
Attachment 3
Attachment 4
![]()