Here is a snippet of code
Expand|Select|Wrap|Line Numbers
- ' Check if the word has been translated
- If WordNo = 4 And LanguageID = 2 Then Stop
- Criteria = "[WordNo] = " & CLng(WordNo) & " AND [LanguageID] = " & CLng(!LanguageID)
- WordSet.MoveLast
- WordSet.MoveFirst
- WordSet.FindFirst Criteria
- If WordSet.NoMatch Then ' Not yet translated
- TranslatedWordNotFound = -1
- GoTo TranslateIt
- End If
If the criteria is Word = 2 and Language = 4 it works
I have tried with & without the MoveLast & MoveFirst before applying the Criteria
I have tried with & without square brackets
I have tried with & without CLng
I am at a complete loss. Grateful for a soluion
Thanks
Phil