Not sure what the error is

G

Guest

I do not know what the problem is, and looking for suggestions. I have a form
with 1 combobox and 2 buttons. Combobox gets populated from query, no
problem. one button just closes the form and the other brings up a report in
preview mode based on the value from the combobox. For some reason clicking
on either button I get an error

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

• The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure]
• There may have been an error evaluating the function, event, or macro.

When I go to the help that they link you to:
http://support.microsoft.com/kb/283806/EN-US/ - Visual Basic for
Applications (VBA) functions break in a database with missing references

The description does not match. There are no references missing. I have
even tried to use: http://support.microsoft.com/kb/209849/ - How to
loop through the references to view their properties in Access and none are
shown as missing.

Short of deleting the form and recreating, don't know how to correct. I
have done several Repair and compacts, but this did not change anything.

Need suggestions.

Kenny A.
 
J

John W. Vinson

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

• The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure]
• There may have been an error evaluating the function, event, or macro.

Open the form in design view, and view its properties. Take a look at the
Events tab. If any event property has something other than blank or [Event
Procedure], then that's likely the problem (the only other valid values are
the names of stored macros).

If it's not in the Form properties, check the Event properties of each control
on the form.

John W. Vinson [MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top