logic question

  • Thread starter Thread starter coyote
  • Start date Start date
C

coyote

Thanks for reading my post. The following If condition never evaluates as
true, although there are records in my DB which meet the conditions. Any
clues what I'm missing?
I don't get any compile errors...

If (((rsTMPMedals("Division") = """ & strDivision & """) And (rsTMPMedals
_("GroupID") = strGroupID)) _
And ((rsTMPMedals("ConID") = strConID) And (rsTMPMedals("EntryID") <> _
strEntryID))) Then


thanks Randy
 
The doubled up quotes are not appropriate in this context.
You are not concatenating the value into a string.

With rsTMPMedals
If (!Division = strDivision) AND (!GroupID = strGroupID) AND (...

End With
 
Back
Top