Subform wierdness

R

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.
 
D

Damian S

Hi Rolls,

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

Damian.
 
Top