Subform wierdness

[Rolls]

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.

 

[Guest]

Hi Rolls,

What you are describing sounds like a Requery is being triggered... are you
sure there are no events behind your form?

Damian.

 

[Rolls]

There aren't any. That is what puzzles me. Must be more subtle.