how do I add code to the close command and where do I put it?

[banditson]

I am just begining to work with code so, this may be simple? I have created a form command that closes a form, maximizes the ribbon, opens a table and deletes any records in it. I will then append records to that table. I would then like to close the table and reopen the "info form" again. How and where do I write the code to do this? You can see that I have the close command line commmented out below. I think that is correct but, where do I do all of this?
Private Sub Option32_Click()
DoCmd.OpenTable "xxx xxx", acViewNormal, acEdit
DoCmd.Maximize
DoCmd.close acForm, "Info Form", acSaveYes


DoCmd.ShowToolbar "Ribbon", acToolbarYes
DoCmd.RunCommand acCmdSelectAllRecords
DoCmd.RunCommand acCmdDelete
''DoCmd.close acTable, "PIP PINS", acSaveYes
End Sub

[ajetrumpet]

you're deleting all of the records in a table. that is NOT the way to do it. the way TO do it is like this:

currentdb.execute "delete * from [xxx xxx]"

one line of code, DONE.

now trust me, I'm not making light of your concerns, but this is a classic example of novice coding, and it's simply because beginners usually tend to cling to the "docmd" object, because it has one of the largest dropdown items for the intellisense in VBA, second to only the "docmd.runcommand" code, which has hundreds of commands to execute (I think). the other thing is that beginners tend to use it because the "wording" of the dropdown items can be significantly correlated with interface features and menus. Hence, interface users identify well with the menu, and furthermore, know what it means.

that's the very first thing you need to do here.