Run-time error 424 Object Required

[Sheldon]

Hi,

Does anyone know what this means? I'm recieveing this
error after adding the following code to Open Form Event:

if me.fldname.value is not null then
me.fldname.locked = true
else
me.fldname.locked = false
endif

I'm a beginner, so please pardon my ignorance. Thanks.

Sheldon...

 

[Terry]

Hello Sheldon
This usually means that the control FLDNAME is not
defined. Check the spelling of the name. Is it showing in
the Autocomplete???

If you enter DEBUG which line is selected?

Use
If Not isnull(Me.fldName) then
rather than if me.fldname is not null

If this is occuring in a report (not relevant for this
situation but additional info) make sure the filed appears
on the report (make it invisible if not required for the
actual report).
HTH
Terry

 

[Sheldon]

Thanks. I was using improper syntax.

-----Original Message-----
Hello Sheldon
This usually means that the control FLDNAME is not
defined. Check the spelling of the name. Is it showing in
the Autocomplete???

If you enter DEBUG which line is selected?

Use
If Not isnull(Me.fldName) then
rather than if me.fldname is not null

If this is occuring in a report (not relevant for this
situation but additional info) make sure the filed appears
on the report (make it invisible if not required for the
actual report).
HTH
Terry

.