Operator Like using wildcards with variables..

[Dominaz]

Hello!


I want to use the operator like to compare two fields of two different forms and then give a value to another field...

If Forms!Teachers!Subject.Value Like Forms!Booking!Subject.Value Then
Forms!Teachers!Score.Value = 2
End If

This works fine, but if I want to use * ,(Maybe someone write Math, instead on Mathematics....) then things doesn't work...


If Forms!Teachers!Subject.Value Like Forms!Booking!Subject.Value & "*" Then
Forms!Teachers!Score.Value = 2
End If


2) I also have another question, How can I use the like operator to compare only the first 3 characters of two fields ???

Thank you very much.

[Robeen]

For your second question - try something like this:

If Left(Forms!Teachers!Subject.Value, 3) Like Left(Forms!Booking!Subject.Value, 3) Then . . .

Let me know if that works.