ODBC upate on a linked table failed

[Tim]

I have a form that allows the user to Edit and Filter (properties). The
record source is a table (i.e., Student) linked with a second table by a key,
i.e., RoomID with one-to-many relationship.

The user forgot to input data into one field (nvarchar datatype) on the
form. When he goes back to the record and input a value, it pops up an error
message, "ODBC update on a linked table failed. Maximum stored procedure,
function, trigger, or view nesting level exceeded (limit 32). (#217). How can
I fix it? Thanks

 

[Tom van Stiphout]

On Mon, 8 Feb 2010 06:03:01 -0800, Tim <[email protected]>
wrote:

You possibly have a bad trigger on that table. Check that first.

-Tom.
Microsoft Access MVP

 

[Tim]

Tom, thanks for response. I do have an update trigger on this Student table.
Whenever the user inputs a value, say, Title, will trigger another field in
this Student table to be updated. But these fields have nothing to do with
the nvarchar field I mentioned.

I suspect this nvarchar field is empty or null and the trigger has no code
to deal with null or empty field. However, the form_close event and
field_exit event have been programmed to pop up a message prompting the user
to input a value for this field. So it's strange to me. Do you have any idea?
Thanks