I have 2000 ACCESS db that someone converted from 97 to 2000. Most
everything seems to work, but one button. This is a SEARCH button
that involces a Macro called Utility.Search. The macro does a
RunCommand Find, which brings up a find dialogue box. When I put in
my search string and hit enter, it come up with an error:

The Control "SearchBtn" the macro is attempting to search can't be
searched. Try one of the following: *Add a GoToControl action before
the FindRecord action. *For the FindRecord action change the Only
Current Field action arguement from Yes to No. *Change the focus to a
searchable control.

This also happens when I press the Find button (binoculars) on the
menu bar.

It worked fine in 97 but now is not working in 2000. Since this is a
"SYSTEM" command, I can't figure out what it wants. I did go in and
add references to the DAO and ActiveX reference libraries.

I tried a search on this forum, the ACCESS help, and also the MS
Knowledge base but came up empty.

Anyone with any ideas?

TIA.

bc

OK

Figured out the problem. The message is correct. What is happening
is that the control "SearchBtn" has the focus of the program instead
of the field on the form or the db table. If after putting in the
search term, you can change the focus back to the form field. Then
press Find Next, it should work. If that fails, close the Find
Replace window. Click on the binoculars on the toolbar. Enter your
search term. Click back on the report field. Click on Find Next
and it should work.

As can be seen this is a pain and I feel a definite ACCESS bug. Like
I said above, it worked in 97 with no problems but not with 2000. If
anyone knows of something that is happening here that can be fixed,
please let me know.


bc