What if FINDFIRST didn't find anything 1

[tattoo911]

I have the following line of code.

Me.RecordsetClone.FindFirst "[CustNum] = '" & Me![Combo29] & "'"

How do I wrap this in an IF statement to determine if it actually found a match to what was entered in COMBO29.

I tried .NoMatch but that didn't work...


thanks

 

[RuralGuy]

Are you saying that this didn't work?
If Me.RecordsetClone.NoMatch Then
'-- No record located
Else
'-- Record located
End If



HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit

 

[MichaelRed]

do you know about the ubiquitous F1 (aka Help). FindFirst is generally recognized as a keyword.




MichaelRed