vendredi 18 juin 2021

VBA Access If statement doesn't contain a certain character

I am trying to write in Access an If statement that changes the value of a form value depending on the fact that another value doesn't contain the character "*".

So far, I have this :

If Forms![Saisie commande panier]![Qualité].Value = "CA" _
Or Forms![Saisie commande panier]![Qualité].Value = "Salarié" _
And Not Forms![Saisie commande panier]![SF_Panier]![SF_Détail_panier]![Designation].contains "*" Then
Forms![Saisie commande panier]![SF_Panier]![SF_Détail_panier]![Remise] = "30"

Which, of course, is not working. Do you have any solution for that ?

Knowing that this form is a spreadsheet. NOT LIKE doesn't work, <> doesn't work either... There must be a simple function, right ?

Thank you for your help, Flo

Aucun commentaire:

Enregistrer un commentaire