Access Forms - Error

[jimmidopolus]

Hi all, hopefully a guru can help me out with this teaser!

I have a form in access that I'm using to pass variables through to SQL statements in VBA, so it is effectively a selection screen.

To help the User I have used combo boxes which obtain the values from a GROUP BY SQL SELECT statement in the rowsource property.

The data in the combo boxes is working fine.

However, Whenever I try to operate a command button (even to simply close the form), the following error is received:

"The expression On Click you entered as the event property setting produced the following error: A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control."

Any ideas to why and get the form up and running?

Cheers

jimmid

 

[jimmidopolus]

All is working again!

Simply got away with copying the form and deleting the original. Put it down to Microsoft.