OLE Server Error from List Box Update (1 Viewer)

[Cotty42]

Hi All

I have a form which uses a list box to select which record to display. The code is all generated by Access during form design. It is a method I have used numerous times inthe past in various database without problem (even in the current database I am developing).

But for some reason on this one form I get the following error;-

"The expression After Update you entered as the property setting produced the ollowing error; A problem occurred while database was communication with OLE Server or Active X Control"

Any ideas why this is occurring and how I can stop it.

Many Thanks

Dave

 

[pr2-eugin]

Perform a Compact and Repair followed by a compile. See if the error persists.

 

[Cotty42]

Hi Paul

Thanks for this. Tried it but am still getting the same error. What's odd is that the same code works in other forms in the database, it is just this one.

I have checked for name conflicts and deleted the form and started again but still keep getting this error.

Cheers

Dave