Strange findfirst behavior

[Shyguy]

I have a combo box that finds a record on the form, and for the most
part it works fine. But, on occasion it brings me to the record just
before the one I am looking for. If I compact and repair the database
it works correctly again. Sometimes I have to compact and repair
twice.

Any help would be appreciated

[Wayne Morgan]

It sounds as if something is corrupting the index on the field you are doing
the search on. Please see this link for information on avoiding corruption.

http://www.allenbrowne.com/ser-25.html

--
Wayne Morgan
MS Access MVP
"Shyguy" <sh****@aol.com> wrote in message
news:j8********************************@4ax.com...

I have a combo box that finds a record on the form, and for the most
part it works fine. But, on occasion it brings me to the record just
before the one I am looking for. If I compact and repair the database
it works correctly again. Sometimes I have to compact and repair
twice.

Any help would be appreciated

[Shyguy]

Thanks for the link. I'll have to go through it later. ;-)

On Mon, 19 Dec 2005 04:45:03 GMT, "Wayne Morgan"
<co***************************@hotmail.com> wrote:

It sounds as if something is corrupting the index on the field you are doing
the search on. Please see this link for information on avoiding corruption.

http://www.allenbrowne.com/ser-25.html