Locking fields after fill

[Magnus1982]

Hi,

Let's have a form which have 10 fields and after fill up some of the field for example five that's five should lock up. To change this five (locked) in the future should be check box which can unlock that's filed to make modification. For me is to hard...

[jwhite]

1. On fill of one of the "fields" (controls on the form), in the AfterUpdate event, if the control has a value then set the appropriate checkbox control to False, and lock the control (Me.ContrlName.Locked = True).

2. On tick of a check box control, test if the value is True - if so, then unlock the corresponding control for data entry.

[Bulzie]

If they just have to click a box to be able to edit the fields again, what's the point of locking in the first place?

[jwhite]

Perhaps to protect against "accidental data updates".

[Magnus1982]

hi,

the thing is , In one I have date ,operator, batch number, parts number , aliment check, power check an on the same form on left site of screen i have aliment verification ,date veryfication ,operator. . Now operator is writing down first few data (bolt words) after 24h is doing verification for aliment (Tilted and underlined). That's why i need first data (bold words) locked after fill in. My way with access is beginning . When i will sort this problem i need to do the barcode read and logins for diffrent operators . I hope on this forum i will find help.Also i assume after finish my work on this i will know solid basic on access. Sorry for English it is not my first langue

[jwhite]

So this particular problem is solved? If not, please explain.

[Magnus1982]

Yes I solved. Tnx