I am updateing an Access 97 table. I have a Primary Key set up on a multiple field index. To reference the Index from VB My statement is:
rsInvhd.Index = "Rp0753sIndex"
I get no errors but my seek (rsInvhd.Seek "=", strSeek) does not work. I've checked field and search string lengths. What's the secret?