Lock Field After Update-Access2K

  • Thread starter Thread starter Sheldon
  • Start date Start date
S

Sheldon

Hi,

I'm able to lock a field after update by using the code:

fldname.locked=true

But when the form is closed and reopened, the field is not
locked. How can I keep an updated field locked?

Thanks.

Sheldon...
 
Hi Sheldon,

have you try putting the code in the Form Open Event?

----- Sheldon wrote: -----

Hi,

I'm able to lock a field after update by using the code:

fldname.locked=true

But when the form is closed and reopened, the field is not
locked. How can I keep an updated field locked?

Thanks.

Sheldon...
 
Is there a value in the field before you update it, or is it an empty field

If what you want is someone to fill in an empty field then lock the field for good use

do this on Form Open

if me.fldname.value is not null the
me.fldname.locked = tru
els
me.fldname.locked = fals
endi
 
I'm not sure what you mean. I want only certain fields to
lock after they are updated. I don't want them
necessarily locked on Form Open.

Sheldon...
 
Thank you. This is what I am trying to do!

Thanks again.


-----Original Message-----
Is there a value in the field before you update it, or is it an empty field.

If what you want is someone to fill in an empty field
Click to expand...
then lock the field for good use:
 
Back
Top