Close a Form w/ Cmd Button

[humphreya]

I am building a database to track employees. I have a form to input the personal information and want to close this form and open a new form to input the employee's training information. I have a cmd button to open the Training form for the individual, however I can not make it close the employee input form.

Can someone help with this?

 

[RuralGuy]

After the line that opens the other form put:
DoCmd.Close acForm, Me.Name, acSaveNo

 

[JohnD]

RG,

I have the same set up on my forms, however I just use this

DoCmd.Close acForm, "MyForm"

should I be using Me.MyForm instead of placing my form in ""?

Also, im assuming the acSaveNO is simply telling it to not save any changes made?

thanks

John D

 

[RuralGuy]

Hi John,

My syntax is just more generic. Your syntax is just fine and specific to your form. The acSaveNO says do not save any changes made to the Form design and has nothing to do with data shown in the form.

 

[JohnD]

Simple enough - thank you!

 

[humphreya]

Thanks, that help alot. Sorry I did not reply sooner, I only work on this db about once a week.

 

[RuralGuy]

You are very welcome, glad I could help. Merry Christmas!