If statement logic

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

coyote

Thanks for reading my post

The following If statement never 'finds' a record in my DB, while there are
records which satisfy the conditions....

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

Have tried reducing the parens, but thought it might only be able to
evaluate the And's with two items at a time, so I added them...
 
I am guessing that the quotes are not padding each side of of
rsTMPMedals("Division")


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