More edit allowed yes or no queries

  • Thread starter Thread starter mon
  • Start date Start date
M

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
 
You are all fantastic.
Click to expand...

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
Click to expand...

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

TC
 
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
 
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
 
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
 
Yep - I answered it there.

TC


mon said:
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
Click to expand...
 
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
 
Back
Top