LinkMasterField Error

[LarryAT]

Win98/MS Access 97 OSR-2

I have a form/subform that works fine for a while and then I get the following error:

The LinkMasterFields Property Setting has produced this error 'Invalid outside procedure'.

Once I get this error then Access no longer updates the child field in the subform.

I have looked in Microsofts Knowledgebase and there was one hit talking about a similar error if the linked fields had the same name as a property. I'm sure these did not, but I changed them anyway and I still got the error.

I have tried this on different pc's and osr-1 and 2, with the same results.

Help!

Larry Tiner

 

[RickSpr]

It might not have to be the actual link fields that are named the same as a property - it could be any field in either the main form's or subform's recordsets. "Name" is a particularly common one for this kind of collision.

Think about what's happening in the background when you have a linke subform. Access is repeatedly modifying the subform's Record Source query (not the property, the actual form Recordset) to restrict the subform to showing data related to the main form's link field. Any field referenced in the revised query is going to be interpreted by VBA and the SQL engine. Ambiguous names are bound to cause problems. Also, watch out for text values that contain embedded ' or " characters; that could cause a problem.

Rick Sprague