Adding a filter to a form

[TKM]

I have a main form based off a loan number. Each loan number begins with 041,
010, 020 etc followed by 00002006, 00001933 etc to look like 040-00002922.

I need to have a filter or case statement somehow filter the 041 and loan
numbers to only show certain condition codes. The condition codes are
attached to item description in subforms.

I have idea where to begin and hoope someone can help?

 

[OldPro]

I have a main form based off a loan number. Each loan number begins with 041,
010, 020 etc followed by 00002006, 00001933 etc to look like 040-00002922.

I need to have a filter or case statement somehow filter the 041 and loan
numbers to only show certain condition codes. The condition codes are
attached to item description in subforms.

I have idea where to begin and hoope someone can help?

Since the condition codes are part of the detail, then the 041, 010,
and 020 numbers must not be condition codes, as they are clearly part
of the loan number. So why did you mention them? And why would you
want to filter them? Wouldn't you want to see all conditions that
apply to a particular loan?

 

[TKM]

Currently we have condition codes that are assigned to each tab. Tab 1, tab2
and so on. We just took on another client that wants to change and add a few
additons to the condtion codes and item descriptions. So Instead of showing
him all of the conditions for each tab that is assigned to all loan numbers.
I need a way to filter the CC so they can only se4e there codes and item
numbers.

Make sense?

 

[OldPro]

Currently we have condition codes that are assigned to each tab. Tab 1, tab2
and so on. We just took on another client that wants to change and add a few
additons to the condtion codes and item descriptions. So Instead of showing
him all of the conditions for each tab that is assigned to all loan numbers.
I need a way to filter the CC so they can only se4e there codes and item
numbers.

Make sense?






- Show quoted text -

I think I understand; you will have two sets of condition codes, just
one of which is assigned to each loan. It sounds like you need a
class code so you will know which set of condition codes to use.

 

[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

 

[TKM]

I have codes 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.

 

[OldPro]

By tabs in a subform, do you mean columns? I don't believe you can
change a subform column header on-the-fly. Perhaps you could have
multiple subforms, and select which ones to show on the form on-th-
fly. If there is a tabbed dialog that is on the same form as the
aforementioned combobox, then the captions for each page can be
updated. Each tab has a page name, with which its properties can be
accessed. Personally, I would go a different route: I would program
the whole thing and not use subforms. It is a lot more work, but
gives the programmer complete control over the result. I wouldn't
recommend that route unless the programmer was expert in Access and
VBA.