By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,452 Members | 974 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,452 IT Pros & Developers. It's quick & easy.

Strange findfirst behavior

P: n/a
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

Dec 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Dec 19 '05 #2

P: n/a
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


Dec 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.