Time Card Signature - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Time Card Signature

Sharon Esdaille

5 years ago

Employees need to sign timecards. Once signed no edits should be made. I have a signature textbox. Once signed I disabled the signature box and locked form fields. When I close and reopen the timecard, the signature is gone, signature box is re-enabled and form fields are now editable. What am I missing?
Thank you for your help.

	Sharon Esdaille OP @Reply 5 years ago
I think I figured it out. I was using an unbound text box. Once I created a field on my table to hold the signature value, now it stays.

	Sharon Esdaille OP @Reply 5 years ago
Okay. I didn't fully figure it out. The value stays now that I'm no longer using an unbound text box, but when I close and reopen the form, the fields that were disabled after update, are now enabled. I'm missing something else.

	Richard Rost @Reply 5 years ago
In addition to your AfterUpdate event, you need code in your OnCurrent event so that it disables the proper fields when a record loads too.

	Sharon Esdaille OP @Reply 5 years ago
Ahh. I see. Thank you. I will try that.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View