Change caption and even procedure of button afer clicking it

[adambedford]

Hi,

I have this code:

DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide

DoCmd.SelectObject acTable, , True
DoCmd.SelectObject acForm, Me.Name

to show and hide the Access database window/navigation pane...

Is there a way to incorporate both pieces of code into one button. i.e. initially the caption reads "Hide Navigation Window", but after clicking it, it reads "Show Navigation Window".

Thanks!

 

[adambedford]

perfect, thanks!