autofill breaks after compact&repair

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

using combo box with three fields, one of which is the primary key. I can
paste in the box and autofill works (search by ItemNum, but bound to
barcode((Primary key)))

after c&r, tping in an item on the list will generate a not in list error,
but clicking on the item in the list will work, and autofill quits.

I'm assuming that c&r modified my index, but I'm at a loss as the primary
key values have not changed?

Code in forms over a year old still works, so this may have been an update
"added feature".

Applies to XP and 2007
 
duh! got the answer from a post by GlisBeukenneet on another topic,changed
the primary key to the first column & adjusted other parameters accordingly
 
Back
Top