I'd like to create an If/Then statement in VBA where if there are multiple records in the recordset one message populates, and if there is only record another message populates.
Right now I'm using
If rst.EOF = False Then...
Else ...
End If
This is only returning the first condition regardless of how many records are in the recordset though.
Is there something else I'm missing?
Aucun commentaire:
Enregistrer un commentaire