Tabbing creates multiple records

[adamstuff]

I can't believe how helpful you folks are and how dumb I can be.
I have a subform, bound to a table, with data entry property set to yes, because I want blank fields to start. There is no record recall/display, only data entry. The subform has 6 fields. When I tab from one field to another to put in test data, if I hit the tab key on the last field in the tab order, the cursor jumps to the first field in the tab order, zeroes out the first 3 fields and creates another record. Every time, so I can create lots of records unintentionally.
I thought the cursor was supposed to jump to the first field in the main form, at least that's what I read. There is almost no coding in the subform. I'm a newbie, wouldn't know what to put in there anyway.
I suspect it's cuz of data entry being set to yes, but I don't know of another way to display zeroes in fields on form open. They are all numeric. I would like arecord only to be created if some fields are dirty(?) when the user hits the SUBMIT button and not otherwise, but I think that's another question, unlse it is related some how.
TIA

Heisenberg was probably right.

 

[edsuk]

What is the Cycle Property you have set on this form? From what you are saying it may be set to 'All Records'. Try using "Current Record".

HTH

 

[adamstuff]

Hi edsuk,
I have changed both main and subform cycle properties to current record and to all records. Bad operation is not affected at all. I have no event procedures on the subform. I have no problems with the main from table. I'm lost. I appreciate your input. I have no idea where to turn.
Thanks

Heisenberg was probably right.