Form Search Button

J

Justin

Hi

I have almost finished a database and it does everything
I want it to at the moment except one thing. On the Forms
that I have made, I have placed some find/search buttons
that seem to work once or twice(can't find any
consistency into why they work one minute but not the
next) and then spit out errors:

The control 'close' 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 argument from Yes to No.
*Change the focus to a searchable control.

When it does work, it seems that the Look In: option is
greyed out, but it does contain the correct table anyway.

I can't find an answer anywhere, so any advice would be
much appreciated, but I know nothing about macros and VB
so as basic as possible please. I thought that these
search buttons would just work of their own accord, and
they do once or twice, but 99% of the time the above
error is repored ???
 

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