Multifaceted Button

[LKE]

Hi...

I'm trying to figure out how to place a button on Form 1 that a.) saves and closes Form 1 and b.) opens Form 2 to a blank record. Any thoughts??

Thanks very much!

 

[chrismcbride]

DoCmd.Close acForm, "frmOne", acSaveYes
DoCmd.OpenForm "frmTwo", , , , acFormAdd
HTH
Chris

 

[Cosmos75]

How about a button on a Query-by-form that runs the query and automatically opens the associated Report (or one secified that is based on the QBF?