Hi, Plz note, My "VBA" is disabled at work for security reason
Plz in your explanations use only Expression builder, Macros, Queries, Tables, Forms or Reports only.
Plz understand my circumstance
---------------------------------------------------
I have Order Form and its approval history
Picture 1
I want it to prevent me from submit the status twice and a message appears that "you cannot send twice, please make a new submission"
Picture 2
If you open the same form, the command button should not return to the enabled state, It must remain disabled, it should be only enabled with the new record
plz help me to do it
Plz in your explanations use only Expression builder, Macros, Queries, Tables, Forms or Reports only.
Plz understand my circumstance
---------------------------------------------------
I have Order Form and its approval history
Picture 1
I want it to prevent me from submit the status twice and a message appears that "you cannot send twice, please make a new submission"
Picture 2
If you open the same form, the command button should not return to the enabled state, It must remain disabled, it should be only enabled with the new record
plz help me to do it