Combo Box and SQL

[Sean Nijenhuis]

Hi and thanks!

I have an Access 2000 that uses an ODBC link to a SQL Server (7.0). Very
basic form to look up basic information on Borrowers. Everything surrounding
capturing, editing, printing etc works fine. There are roughly 16000 records
in the table.

In my quest for user friendliness i thought I would utilise the Combo Box
wizard to add a "Find" box onto the form using the surname field.

After "Finding" a couple of times, the Combo boxes goes wonky - no matter
what name i type in, it jumps to a record of its choice - completely
randomn.

Why? and should I not be using "Find" combo boxes? What should I be doing?

Thanks
Sean

 

[Jacek Segit]

Witaj Sean,
W Twoim li¶cie datowanym 28 kwietnia 2004 (20:27:20) mo¿na przeczytaæ:

SN> Hi and thanks!
SN> I have an Access 2000 that uses an ODBC link to a SQL Server (7.0). Very
SN> basic form to look up basic information on Borrowers. Everything surrounding
SN> capturing, editing, printing etc works fine. There are roughly 16000 records
SN> in the table.
SN> In my quest for user friendliness i thought I would utilise the Combo Box
SN> wizard to add a "Find" box onto the form using the surname field.
SN> After "Finding" a couple of times, the Combo boxes goes wonky - no matter
SN> what name i type in, it jumps to a record of its choice - completely
SN> randomn.
SN> Why? and should I not be using "Find" combo boxes? What should I be doing?

Maybe it helps:
http://support.microsoft.com/default.aspx?scid=kb;en-us;254822

But sometimes I had problem you described and after few experiments
I did I found possible "reasons":

Sometime it happen when table has a cluster index (different to
primary) and generally this problem is IMHO connected with indexes.
Check if you havn't unnecessary indexes and/or try to add/remove
one.

Regards
Jacek Segit