How to unable button on form

[luzz]

How to disable button on form

Hello guys, how do i disable my edit button on my form after clicking on "Save" or "Clear" on my form?

 

[isladogs]

Add the following line to the Save and Clear button event code

 Me.cmdEdit.Enabled = False

Where cmdEdit is the button's name - modify to match yours.

 

[luzz]

Add the following line to the Save and Clear button event code

 Me.cmdEdit.Enabled = False

Where cmdEdit is the button's name - modify to match yours.

Sorry, I think I did not express myself clearly. I want my button to look (at the picture below) like that when i open my form and after i have click save.

 

[isladogs]

Well I thought I'd already answered that!

Me.cmdEdit.Enabled = False

disables the Edit button

Me.cmdEdit.Enabled = True

enables the button

In design view make sure the button is ENABLED.
Save the form
When you next open the form the button will be ENABLED

Then in the code for the Save button, add the following line to disable the button

Me.cmdEdit.Enabled = False

If you are using macros instead of VBA code, I can't help you as I don't use them.

Good luck with your project (for both current threads)

 

[luzz]

Well I thought I'd already answered that!

Me.cmdEdit.Enabled = False

disables the Edit button

Me.cmdEdit.Enabled = True

enables the button

In design view make sure the button is ENABLED.
Save the form
When you next open the form the button will be ENABLED

Then in the code for the Save button, add the following line to disable the button

Me.cmdEdit.Enabled = False

If you are using macros instead of VBA code, I can't help you as I don't use them.

Good luck with your project (for both current threads)

Thanks! It works, but how i click on 'Save" button and the records on the from will automatically clear and the "Edit" button will be able again? Currently, when i save my record after editing, i will have to click on clear button before i can proceed to use the edit button to edit the record that i have selected in my subfrom? By the way, i am using VBA code

 

[isladogs]

Thanks! It works, but how i click on 'Save" button and the records on the from will automatically clear and the "Edit" button will be able again? Currently, when i save my record after editing, i will have to click on clear button before i can proceed to use the edit button to edit the record that i have selected in my subfrom? By the way, i am using VBA code

Sigh ....
In that case there is no point disabling the Edit button ...
I'm sure you can work out the logic you need and just attach the relevant code to whatever button you think best

Over & out