Search Key Not Found while searching in a form

B

blue10liberty

I can search in a table using the "binoculars" with no problem. When I try
to do the same in a form, I get the message "search key not found". How do
I correct this so I can search in a form?
 
A

Allen Browne

blue10liberty said:
I can search in a table using the "binoculars" with no problem. When I
try to do the same in a form, I get the message "search key not found".
How do I correct this so I can search in a form?

The most likely cause is a bad index. A compact/repair may fix that.

If not, you may be able to identify the corrupt record, and rebuild the
table with the other records. Details in:
http://allenbrowne.com/ser-47.html#RowsShowDeleted

It is also possible that the problem is caused by some code in the events of
the form.
 

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