AfterInsert

[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.

 

[dale]

I tried that and it gave me an error.

 

[Stephanie N]

on the after update event type in me.subform.setfocus

 

[dale]

Sorry, It worked. I tried it in the afterinsert

 

[Stephanie N]

sorry you need to type in Forms!MainFormName!SubFormName!FieldName.Setfocus

 

[dale]

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

 

[Stephanie N]

Docmd.RunCommand ACCMDSaveRecord will save the record

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

 

[dale]

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

 

[Stephanie N]

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

 

[dale]

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

 

[Stephanie N]

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