Lock Field After Update-Access2K

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

..
 
R

Rod Scoullar

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error 424 Object Required 2
VBA - exporting serial letters to single documents 0
Reading a field when field is locked? 15
Lock fields in subform except two after authorization date is ente 6
Lock Field After Update-Access2K 4
VSTO C# add in Outlook.Appointment error 0
Locked fields 1
is locked vs. after update 4

Top