Field Modification Question

[snackcakes101]

Hi! I have a db for my traffic department. One user has all creation and editing rights (not scripts and layouts). When she clicks the "Create New Job" button, my script adds a new job into the system and creates a new job number. Once that job number is created, I don't want the user to be able to accidentally modify this field.

If I give her 'read only' rights for that field, the script to add the new job number doesn't work (field is not modifiable). If I uncheck "allow entry in field" and approach it that way, she cannot do a search on job numbers, which is the most common search needed in her dept.

Is there a way to tell the system to allow modification for creation, but then lock it? Jobs are only created in the "Job Number Log" layout, but searches are done in at least 3 other layouts.

Thanks so much!

[BobWeaver]

Create a calculated field:

cJob_Number = Job_Number

and put cJob_Number on the layout and allow entry. It can then be searched, but not modified.

[danjacoby]

Create a calc field that equals the job number field, and put it under the job number field. Then, when she does a find, she'll actually be entering find data in the calc field.

Oh yeah -- uncheck "allow entry..." in the actual job number field, and remove it from the tab order.

[snackcakes101]

Thanks, guys! I tend to grasp the complicated steps but sometimes miss the obvious.

Keeping it simple,

Debi

[danjacoby]

BobWeaver -- you get credit for slipping in ahead of me (just barely ahead of me).

Timing is everything.

[BobWeaver]

Ha! Fastest mouse finger in the west!