Allen Bowns FindAsUType2000

[sandrao]

I downloaded FindAsUType and was wondering if there is anyway to
eliminate some of the fields that are collected with the Value List.

Basically I would just like to access two fields one a name field and
the other a language field.

the rest of the field are composed of check boxes that are of little
use in the search.

If Allen is watching or anyone else let me know

sandrao

 

[Allen Browne]

Does it actually load the check box field names into the combo?

A quick look at the code at:
http://allenbrowne.com/AppFindAsUTypeCode.html
suggests that it only examines the text boxes and combos.

An alternative might be to use this approach to filtering:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

 

[sandrao]

Does it actually load the check box field names into the combo?

A quick look at the code at:
   http://allenbrowne.com/AppFindAsUTypeCode.html
suggests that it only examines the text boxes and combos.

An alternative might be to use this approach to filtering:
    Search form - Handle many optional criteria
at:
   http://allenbrowne.com/ser-62.html

--
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.










- Show quoted text -

I tried the other suggestion but the problem is that the information
is contained in a subform

MagazineDeptSub and the search will not work while imbedied in the
main form but on its own it works well

 

[Allen Browne]

I tried the other suggestion but the problem is that the information
is contained in a subform

MagazineDeptSub and the search will not work while imbedied in the
main form but on its own it works well

If you want to apply the filter to the subform, you build the filter string
in exactly the same way. The instead of:
Me.Filter = strWhere
Me.FilterOn = True
use something like:
Me.[Sub1].Form.Filter = strWhere
Me.[Sub1].Form.FilterOn = True