subform data entry

[Mark]

I have a subform linked to a textbox on the main form, so
that the operator enters a value, so that only records
matching are shown on the subfrom. This all works ok

When I try to enter new records into the subform, after I
enter the first character into the first field, the entire
record is entered into the table and the subform resorts
the subform datasheet and has the focus on a previous
record.

Why is the subform not allowing all the fields to be
entered?

Thanks for any insight

 

[Jonathan Parminter]

-----Original Message-----
I have a subform linked to a textbox on the main form, so
that the operator enters a value, so that only records
matching are shown on the subfrom. This all works ok

When I try to enter new records into the subform, after I
enter the first character into the first field, the entire
record is entered into the table and the subform resorts
the subform datasheet and has the focus on a previous
record.

Why is the subform not allowing all the fields to be
entered?

Thanks for any insight
.

Hi Mark,

Check for an _OnChange() event

Luck
Merry Christmas
Jonathan