More edit allowed yes or no queries

[mon]

You are all fantastic.
Next I have a subform which is basically a list of
instructions (initial and Further), which I have set to no
editing and no deletions allowed. However I have a Yes/No
field which should be ticked when the particular
instruction has been completed. Can I do that??
Thanks again
Monika

 

[TC]

You are all fantastic.

As a friend of mine used to say:
"Don't cheer - just throw money!"

Next I have a subform which is basically a list of
instructions (initial and Further), which I have set to no
editing and no deletions allowed. However I have a Yes/No
field which should be ticked when the particular
instruction has been completed. Can I do that??
Thanks again
Monika

Not sure what you mean. If the list of instructions is "no editing", how can
the user "complete an instruction"?

TC

 

[mon]

At the beginning of a job the instruction lines are input,
ie 1/Interview Hayes 2/ Take site photos.
I don't want the user to be able to change that field, but
there is a "Completed" Field for the user to tick when the
particular instruction has been carried out. Can I make
only that field editable?
Thanks
mon

 

[TC]

Ah, ok.

Set the form's Allowedits property back to True.

Then, set Locked = True for each control that the user should *not* be able
to edit. Set Locked = False for each field that the user *should* be able to
edit (eg. the checkbox). Then he will be able to tick (or clear!) the
checkbox, but he won't be able to edit the instructions.

HTH,
TC

 

[mon]

Hi Tc and thanks for all your help.
Did you see my entry a few lines up?
Everything is working except I can't enter into the new
record either(It's a database layout)??
thanks again Mon

 

[TC]

Yep - I answered it there.

TC

Hi Tc and thanks for all your help.
Did you see my entry a few lines up?
Everything is working except I can't enter into the new
record either(It's a database layout)??
thanks again Mon

 

[mon]

Sorry, but I still can't enter into a new record. Do I
have to do something different to actually add a new
record? Thanks Mon