I'm having a strange problem entering a field into a subform. As soon as I
type the first letter, the form realphabetizes itself. I then have to move
to the record I entered where the cursor now will replace that letter with
whatever I type next unless I press F2. Then it will let me type the
remainder of the field. Recordsource for the subform is a query sorted
ascending. Why can't I enter a new record before it reacts (badly) when I
try to enter text? There is no code behind events anywhere. I don't know
what causes this. What I expect it to do is wait until all additional
records are entered, then the next time the parent returns to the same ID
everything in the subform is alphabetized.
Damian S - 13 Mar 2007 04:15 GMT
Hi Rolls,
What you are describing sounds like a Requery is being triggered... are you
sure there are no events behind your form?
Damian.
> I'm having a strange problem entering a field into a subform. As soon as I
> type the first letter, the form realphabetizes itself. I then have to move
[quoted text clipped - 6 lines]
> records are entered, then the next time the parent returns to the same ID
> everything in the subform is alphabetized.
Rolls - 14 Mar 2007 12:58 GMT
There aren't any. That is what puzzles me. Must be more subtle.