Access 2007 Contacts Template - error "You can't disable a control

[yrba77]

Hello, I have slightly modified the Access 2007 Contacts Management template
for use as a contacts database at work and I'm having an issue with the "Show
All Records" control object. When I perform the "Quick Search", I get my
results with no problem. I then click "Show All Records". This works fine
unless....

I was testing the modified template and at one point I did a manual "Sort
A-Z" on the last name field. After performing that sort, I tried to click
"Show All Records" again but when I did I received the error "You can't
disable a control while it has the focus" Now, every time I try to use the
"Show All Records", this error pops up. If I click OK on the error box, it
does display all of my records again so the button is still working but the
annoying error keeps coming back as well. The error specifics are as
follows...

Macro Name: Contact List : cmdShowAll : OnClick : Embedded Macro
Condition: True
Action Name: SetValue
Arguments: [Forms]![Contact List]![cmdShowAll].[Enabled], 0
Error Number: 2950

If anyone can help, I sure would appreciate it. I am relatively new to
Access, still getting used to it.

Thank you

 

[yrba77]

Hello, I should note that when I click the "Clear All Sorts" button on the
"Sort & Filter" area, then the "Show All Records" begins to work again.

 

[Fozz]

I also have the same issue. Look forward to a solution.