Public Sub Command1_Click()
if command1.caption = "SAVE" Then
command1.caption = "ADD COMMOND BUTTON"
'Put Save commands here
else
Command1.caption ="SAVE"
'put ADD COMMOND BUTTON Commands here
end if
end sub
------------------------------------------------------------------
Dear Sir,
Thanks for your kind reply. If I press the Save button it should change the caption "save" to "add" and when i again press the button "add" it should change its caption "add" to "save". please help.