subform creates a copy of itself

[michael]

My main form has a date, and my sub form has what happened
on that date.
When i enter on Jan 1st this and that happened - then
close the form - then reopen the form - the date is in the
first record and what happened in the second.
If I do three entries on three different dates - I end up
with 6 records.

Please make it stop!!

michael

 

[John Vinson]

My main form has a date, and my sub form has what happened
on that date.
When i enter on Jan 1st this and that happened - then
close the form - then reopen the form - the date is in the
first record and what happened in the second.
If I do three entries on three different dates - I end up
with 6 records.

Check the Tab Order property of the controls on the form - it sounds
like you're selecting a date, and it's going immediately to the next
record. You can right mouseclick the little square at the upper left
of the form in design view and select Tab Order; if you choose
AutoOrder it will fix the tab order so that the controls will be
accessed left to right, then top to bottom.