Solved Order Approval History (Submit command Button)

[Sarah.M]

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

 

[theDBguy]

Hi. You should be able to use DCount() to check for duplicates; and since you're using a Continuous form, you won't be able to disable the submit button for specific records. It will be all or nothing. So, I would suggest that giving them a warning message or ignore the click if they're not supposed to submit the record.

 

[Sarah.M]

Hi. You should be able to use DCount() to check for duplicates; and since you're using a Continuous form, you won't be able to disable the submit button for specific records. It will be all or nothing. So, I would suggest that giving them a warning message or ignore the click if they're not supposed to submit the record.

Hi, thanks you for ur reply,
Kindly can you show me ur solution by uploading database.
plz!

 

[Gasman]

I am just wondering what vba can do, that queries, macroes etc cannot?

 

[Sarah.M]

I am just wondering what vba can do, that queries, macroes etc cannot?

Thanks for ur reply and understanding
But I will not give up!

 

[theDBguy]

Hi, thanks you for ur reply,
Kindly can you show me ur solution by uploading database.
plz!

Hi. Sorry, I'm not in front of a computer now. I would recommend you give it a try and let us know how it goes. You could also maybe learn better that way.

Sent from phone...

 

[arnelgp]

i replaced your command button with a Textbox and used Conditional Format
to set it to Red background.

 

[Sarah.M]

i replaced your command button with a Textbox and used Conditional Format
to set it to Red background.

Thank you very much!!!