Error message when applying a filter
Posted on 2004-04-01
In Access 2000, I am building a db with a couple of command buttons that either apply or remove a filter on frmDataEntry. By default, frmDataEntry is filtered by "Open" and Site "1"
If I click on the button to remove the filter (cmdRemove), then I receive the following error message: Run-Time error '2766': The object doesn't contain the Automation object 'GenUniqueID.'
My source table, tblData has a field calle lngID set as the primary key. lngID is set up as an AutoNumber field, and it increments at random.
This db has been working fine for three weeks. This error just started to appear yesterday afternoon.
I have tried to repar the db with no luck. I have tried to recreate the form and import all of the code, and I have received the same results.
Any help will be greatly appreciated.
Thanks in advance,