Ok...really frazzled now and need some major help. I am trying to create an index but it is just not working. I keep getting a "Run-time error '3409': Invalid field definition 'DocTitle' in definition of index or relationship.

Here's a code snipet:

Set cmptbl = cmpdb!compliance
With cmptbl

Set cmpidx = .CreateIndex("cmptitle")
With cmpidx
.Fields.Append .CreateField("DocTitle")
.Fields.Append .CreateField("DocDesc")
End With
.Indexes.Append cmpidx
.Indexes.Refresh
End With

Am I missing something here? Definately lost now. Could've sworn it was working yesterday.