AfterInsert

  • Thread starter Thread starter dale
  • Start date Start date
D

dale

I want to know if there is a way to update a field within the record in
the AfterInsert code and allow the form to move to a subform on the
screen. Right now I can update the field but it seems to have to have an
additional tab before moving onto the subform.
 
Stephanie,

I was able to get it to move to the subform but it does not save the
main forms record when doing this. Any ideas of how I can get it to save
the main form record when moving to the subform. I am wanting to update
a field if the user does not enter anything and then have them moved to
the subform when they are tabing out of the main form.

Dale
 
Docmd.RunCommand ACCMDSaveRecord will save the record

And both lines of code should work on the After Update event for the Field.
 
Stephanie,

This still does not fix my problem. It still hangs on the last place of
the form and I have to tab twice for it to save the record. Can I send
you the database for you to take a look at the code. Would that help?

Dale
 
Yes that would help.

Stephanie,

This still does not fix my problem. It still hangs on the last place of
the form and I have to tab twice for it to save the record. Can I send
you the database for you to take a look at the code. Would that help?

Dale
Click to expand...
 
Stephanie,

Do you have another email that I can send the zip file with the
database. The newsgroup will not accept it as it is 4mb.

Dale
 
yes - (e-mail address removed)
Stephanie,

Do you have another email that I can send the zip file with the
database. The newsgroup will not accept it as it is 4mb.

Dale
Click to expand...
 
Back
Top