Need filter or Case statements or both?

[TKM]

User selects a loan number from a cbo. The loan numbers start with 010, 020,
040 or 041 and looks like this 040-00002006. I need to show the correct
condition codes for each group (tabs in subforms) that is associated with the
first three numbers of the loan. How do I do this?

Example 1:

Loan Number: 041-00002877


Condition Code ..................... Group Name

10 ......................................... Borrower
160 .......................................Borrower
23 .........................................Borrower
11 .........................................3rdParty
100 .........................................Zoning
101.........................................Zoning

Example 2:

Loan Number: 040-00001999


Condition Code ..................... Group Name

106 ......................................... Borrower
99 .......................................3RDParty
233 .........................................3rdparty
44 .........................................Zoning
345.........................................Zoning
75.........................................Zoning

 

[Klatuu]

Can you restate your question, please? It is confusing. I can't tell if you
want to return a group name based on a condition or a conditiona based on a
group name nor do you state how I know the value of the one I need to use to
return the other.

 

[TKM]

No i have codes stated above that are associated with certain group names and
those group names and codes go with certain loan numbers. Each loan number
starts with a 040, 041 etc.

Make sense

 

[Klatuu]

No
--
Dave Hargis, Microsoft Access MVP

No i have codes stated above that are associated with certain group names and
those group names and codes go with certain loan numbers. Each loan number
starts with a 040, 041 etc.

Make sense

 

[TKM]

great answer thanks for the help

No

 

[Klatuu]

Scarcastic is okay.
You can't seem to state your question clearly and concisely, so you will
have difficulty getting an answer.
I really was trying to help.