ODBC upate on a linked table failed

  • Thread starter Thread starter Tim
  • Start date Start date
T

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, 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
 
Back
Top