Thisform.CommandButton1.Caption = TableName.Fieldname
This would work assuming your buttons name is CommandButton1 and the button is on the form directly

tip:
Left click on your code window and select Object List from the popup
Select the button or Object you want to work with and a path to the button will appear in your code.

Mike Baty