Conditional macro wildcard help, please.

  • Thread starter Thread starter Maija
  • Start date Start date
M

Maija

I am trying to create a conditional macro and am having
considerable difficultly finding the correct syntax (I'm
very much a newbie to VBA and SQL, I can't even figure out
which one I'm supposed to be using here).

The value of the field "SmplNmbr" is a letter (A, B, C, or
D) followed by two numbers. I would like the macro to run
based on the first letter.

I have tried several permutations in the "Condition"
column:

[Forms]![Logentry]![SmplNmbr]="A*"
[Forms]![Logentry]![SmplNmbr]="A%"
[Forms]![Logentry]![SmplNmbr]="A??"
[Forms]![Logentry]![SmplNmbr]="A##"
[Forms]![Logentry]![SmplNmbr]=[A]
[Forms]![Logentry]![SmplNmbr]="A__"
[Forms]![Logentry]![SmplNmbr]="A[##]"
[Forms]![Logentry]![SmplNmbr]="A[%]"
[Forms]![Logentry]![SmplNmbr]="A[*]"

And I'm no longer sure what all else, all to no avail. My
head hurts. I would appreciate the insight of someone who
is familiar with the correct syntax.

Thank you!
 
Back
Top