Coding a Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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]
 
Back
Top