does the functionality of the demo same as you want.
Sorry I did a bad job of explaining my last reply.
I want the button to be disabled on form open and new record creation. But when I update a certain text field, the button should be enabled.
So the way I've set up the button so far, is to become enabled when a new record is created. Once the button is clicked, it will disable and only become enabled on new record creation. But I don't want it to run this way. I want the button to remain disabled on new record creation and it should only become enabled when a text field of my choice has been updated. After this text field has been updated ONCE, updating the text field again shouldn't continue attempting to enable the button. Only after a new record is created, should this process be repeated.
Here is how the process should run:
1-Open Form and the button is already disabled (I've already done this on the Form's On-Open event as Me.cmdButton.Enabled = False)
2-A new record is created, button remains disabled
3-When a specific text field is updated, the button is enabled
4-Once the text field has been updated once, the button should not continue running that enabling function over and over again (my form's update events are triggered by a save button that I have already setup)
5-Eventually when I need to use that button for a task on my form, I click that button and it runs the function I have coded it for and then disables
6-Only when a new record is created, the process repeats from step2-
Does that make a bit more sense? I know it's a roller coaster.
P.S. New Record is created from a button I've already made as well