Command Button vs Form Button

[Bri]

Hi

I'm uncertain as to when I should be using CmdButtons from the Control
Toolbox vs when I should be using Buttons from the Forms Toolbar. It seems
I can assign code that works fine to either one. I know this is a genereal
question, but are there clear guidelines as to which button is best for what
sort of task? Are there times when one type of button should be avoided?

Thanks
Bri

 

[Guest]

I almost exclusively use cmdButtons from the control toolbox. They are easier
to deal with since they can be easily referenced in code. They have more
properties and methods to play with. The only reason I would ever use the
buttons from the forms toolbar is if I needed the code, that the button is
attached too, to not land in the sheet. This happens if you want to copy the
sheet to another book or such.

 

[Harald Staff]

Adding to Jim:
Controls from the Toolbox will only work properly in Window 1. So if there's
a chance of multiple windows use of a sheet, avoid controls on it and use
the Forms items.

HTH. Best wishes Harald