So far my code is:-
Code: Select all
strFind = "[Description] = " & Chr(34) & CincDesc & Chr(34)
With rs
.FindLast strFind
temp = .Fields("Description")
temp1 = .Fields("CurrentBOM")
End With
CincDesc = the string, brought in from the external file.
This, will find the last record in the table, that matches, the field in the external table.. however, this only matches on one parameter.
I need to match on 3 parameters. ie, the last record in the table, where 3 of the records, exactly, match 3 strings from the external file.
and, if it fails to find a match, i need to divert to other code.
I cannot find any code with .Findlast, to suggest it can do multiple parameters???