Hello,
I have been trying to adapt a form from the Northwind db (Customer Phone List) that enables you to pull up customer information and phone numbers via the command buttons on the bottom (a to z). I have it working except for one error message which I am lost on how to correct. If there is no customer listed under a particular letter in my db, my form gives me the same message box "no customer listed" but then goes into the following error message:
"The object doesn't contain the Automation object 'CompanyFilters'.
You tried to run a Visual Basic procedure to set a property or method for an object. However, the component doesn't make the property or method avaiable for Automation operations.
Check the component's documentation for information on the properties and methods it makes available for Automation operations."
Then it goes to another screen ...Action Failed..where I have to "halt" the macro. Any ideas what would cause this? Thank you very much for any help or advice. It is much appreciated.
I have been trying to adapt a form from the Northwind db (Customer Phone List) that enables you to pull up customer information and phone numbers via the command buttons on the bottom (a to z). I have it working except for one error message which I am lost on how to correct. If there is no customer listed under a particular letter in my db, my form gives me the same message box "no customer listed" but then goes into the following error message:
"The object doesn't contain the Automation object 'CompanyFilters'.
You tried to run a Visual Basic procedure to set a property or method for an object. However, the component doesn't make the property or method avaiable for Automation operations.
Check the component's documentation for information on the properties and methods it makes available for Automation operations."
Then it goes to another screen ...Action Failed..where I have to "halt" the macro. Any ideas what would cause this? Thank you very much for any help or advice. It is much appreciated.
