Weird RecordsetClone Error Message

[MattS]

I have a large FE/BE set up, and part of the FE is a post register. There are two subforms, one for entering post, the other for viewing outstanding post.

A user was in this part of the database, although not active (i.e. using other applications). The following error message suddenly appeared:

"Cannot open a form whose underlying query contains a user-defined function that attempts to set or get the form's RecordsetClone property."

The user did nothing to prompt this, and far as I can tell the queries/tables the subforms are based on do not user any user-defined functions. I am Very confused!!

Any help/ideas appreciated.

Thanks,

Matt.

 

[The_Doc_Man]

Did you create a public function in a general module that is then part of the query? "User-defined" DOES include YOU as a user, you know...

 

[MattS]

Yes, I Know!!

The db contains many public functions created by myself and others, but none of these deal with the RecordsetClone property.

I have one table holding the data. A subform to enter data into the table, and a query to view selected contents. NO user-defined functions.