me! fields cleared on the Form_Close()

S

SteveInBeloit

I have a form where I insert a new record. to do this, I do a
DoCmd.GoToRecord , , acNewRec - and then type in the new values. The form
is bound to a table. I can see the new record on the form after I type it in
and tab to a subform. When I close the form, the form_close fires where I
have some code. This code references the Me! fields. When I walk through it
in debug, the fields contain the values of the first record in the table, not
what was just on the form. then I go to the table, and I can see it did the
insert.

But when I go to this form and display an existing record, and don't do the
DoCmd.GoToRecord , , acNewRec the on close code has the correct values of
what was just in the table.

any thoughts?
thanks
 
Top