Coding a Query

[Gator]

I have a List on a Form and I want to be able to Query by the first letter of
the Record. I am thinking about setting a Click Event for a Label where the
Label if for example "A-B" and the Event would Query all Records that started
with A or B. Do I set up 10 -13 Labels and separate Events for each one? Or
is there some kind of Loop Code I could use? Also, I need help setting up
the code.

 

[KARL DEWEY]

You can use an option group, translation table not joined in query, and
criteria.
Options 1 - 13
Translation table -
Option Alpha
1 A
1 B
2 C
2 D
2 E
3 F

Query design fields ---
SearchField Option Alpha
Criteria ---
Like [Alpha] & "*" [Forms]![URForm]![Frame3]