I mentioned this as an aside in another topic, but it's time to bring it front and center. I have been building several new text lists and they present amazing possibilities. But there is a behavior I cannot get past without just plain getting lucky.
The list I am currently working on has Database Navigation turned on. As advertised, clicking on a line of that list takes me to that actual record in the database. If I have the data sheet open where I can watch it while I do this, the change of record is obvious. Except when it doesn't act this way. Here I am with a certain record highlighted in the text list. I click on another record, and the highlight goes there briefly, then jumps back to where it started. The active record in the database never changed. I can do this over and over and the same thing happens. Same thing if I try to arrow up or down to an adjacent record. The only (unreliable) way around it is to hit the arrow key several quick times in a row, now it may actually move to another record and stay there, but usually fewer records than the number of times I clicked the arrow. For example, if I click the down arrow 5 quick times, it might move 3 records down rather than 5. Just now I tried it again, in 5 attempts to change a record by clicking on another line, it did what it should do 3 times and did the jumpback thing 2 times. I can't find a pattern to it, but definitely some days are better than others. I changed my list to having Database Navigation turned off, and it stopped jumping around, but I can't be certain that this is definitive behavior or just how it is acting now.
If Database Navigation is the key to the problem, then it seems there is a struggle over who is in charge - sometimes the database wins by refusing to change the current record, sometimes the Text List wins by causing the change.
Sometimes I see the same behavior in Help; trying to select a topic in the left pane just results in having the selection jump back to where it was, and I have to keep clicking what I want until it agrees. I suspect that Help is built on the Text List framework and has the same vulnerabilities.
I am trying to narrow down what causes what, but this is also one of those lucky days when I get lots of beachballs and I've already crashed twice doing simple things.
Is anyone else seeing this?