Lock Field After Update-Access2K

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

Sheldon

I inserted this code but I'm getting error message: Object
Required. Please help.

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 then
me.fldname.locked = true
else
me.fldname.locked = false
endif

..
 
Sheldon,

The correct syntax is

If IsNull(me.fldname.value) Then ...

PS. You are usually safe to leave out the .value because value is the
default property

Rod Scoullar
 
Back
Top