>Rule and Trigger Code must balance transaction usage. Full help text:
>
>A rule or trigger expression, or code invoked from an expression, has either started a transaction that it did not finish or finished one that it did not start. The write attempt that fired the rule or trigger code has been aborted.
>
>I have a client who is getting this message on a SEEK. The table in question is loaded by the form, user types in a value to a text field that has no control source, and I do a SEEK on this value. The above error appears, followed by other errors such as "Record is in use by another user" and "Invalid Seek Offset" as I try to quit gracefully.
>
>No code is being written to disk, no updates to the table have been made, I've re-written both the form and the code to no avail. We've re-indexed the files. No change.
>
>Any suggestions?
>
>TIA
>Barbara
Does a SEEK from the command window produce the same results (i.e. table trouble or form trouble) I have had some Invalid Seek Offsets that could not be fixed by reindex, but were fixed by total rebuild of the .cdx
HTH
Glenn
Glenn