Prev: Exporting all forms record either in a table or Excel 2007.( Any m
Next: Making a Time book Form
From: blue10liberty on 18 Apr 2010 11:43
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?
--
Emperial Free Luminesce
From: Allen Browne on 18 Apr 2010 22:30
"blue10liberty" <blue10liberty(a)discussions.microsoft.com> wrote in message
news:DE9EA5D0-B5D0-46F0-BA08-70FD646181BD(a)microsoft.com...
> 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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

 | 
Pages: 1
Prev: Exporting all forms record either in a table or Excel 2007.( Any m
Next: Making a Time book Form