Capturing a date by selecting a button

[vangogh228]

Hello all.

We have product orders that get held in process for a variety of reasons (contract not signed properly, missing drawings, etc). It is our Order Processing Rep's (OPR) responsibility to review the requirements, follow up with the salesman, get the proper documents together and get the order released for product assembly. We capture the date the order was originally held with a date-formatted text field, and then we later capture the release date with a similar field, entered by the OPR.

The OPR is graded on the average time it takes to release a held order. Since they can enter text into the release date field, they can fudge their metric. I'd like to fix this by having a button on the form say "Order Released" and, when it is selected and verified by a second click, the date that occurs is captured in the table under "Release Date" but is hidden from the OPR's ability to edit it.

Can this be done? Any help is greatly appreciated!!

Tom

 

[vangogh228]

Got run off the first page.

Any help? Thanks!

 

[Joe8915]

It sure can, you may search this form. I think it was called tracking or audit trail

 

[vangogh228]

Joe:

Thanks! I didn't have any idea where to start on the search. I found what I needed. I can run an On Click event that sets the date field to Now(), format it how I need, make the date control invisible and the problem is solved. Since my form is run from a query where only Null-valued datefield records are shown, I don't need an IF to make sure they don't overwrite the date.

 

[Joe8915]

Good to hear you found what you were looking for. Here is another great link, I use it quite a bit

http://www.datapigtechnologies.com

 

[comptechbranden]

Nice Link there Joe!