Error 438

[JamesJ]

Hi. Access 2003. I've been using record validation at the form level for
some
time now. I'm checking the value of required "category" field(s).
The code for the record validation hasn't changed in about 2 years.
Now I'm getting the following error my record validation routines:

Error '438': Object doesn't support this Property or Method.

This error is occurring only on one form in my mdb
and four backups that I made this and last month.

Again, I've been using this same function for a couple years with
no problems. Also, on another form the validation code gets ignored (no
error message).
The code runs fine on my other four forms.

Let me know if you want me to copy/paste the routine.

Thanks,
James

 

[JamesJ]

I found that the form that was receiving the error was corrupted.
The form that ignores the function still doesn't work. The function
is being called from the OnClick of a command button but
the form mealy closes.

 

[JamesJ]

I had set a default value for the pertinent field. All
ok now, except for this headache from talking to myself.

Thanks,
James