Locking field based on date (global) field in FMP7

[hlabonte]

Hi all, I'm relatively new to FMP7 and building my first solution. I'm wondering if there's a way to lock a field (from edit) based on some condition. I have a field in my main table, "grade", that should be locked based on a date range of two global fields in my user interface table.

I have the global fields "grade_begin_dt" and "grade_end_dt" set to the date range when the field "grade" should be open. If the current date is outside of that range, I want to lock the "grade" field and prevent any edits.

Any thoughts appreciated!

-Heather

[Ender]

Duplicate post.

[awcase3rd]

hlabonte,

I am uploading a file for you to look at. I made it in fmpro 6 based on your profile. I hope this helps.

-Al

GradeLocking.zip

[hlabonte]

Al, thanks for the file. That looks promising. I'll try that in FMP7 with what I need. I appreciate the code!

-Heather

[CoZiMan]

here is a file, NO SCRIPTS, using the previous sample and the old 'diappearing portal field' trick.

I like this way. No triggers needed !

GradeLocking.fp7.zip