Filter in Subforms via Module-Function 
Author Message
 Filter in Subforms via Module-Function

I copied the Phone-filter from the northwind-MDB in my mdb. But I want
to apply the filter in a subform

With CodeContextObject
        If (.SecondNameFilters = 1) Then
            ' Filter for company names that start with A, , , ?, ?,
or ?.
            DoCmd.ApplyFilter "",
"Forms![AddressList]![AddressListSubform].Form![Name] Like
""[A???]*"""
        End If
        If (.SecondNameFilters = 2) Then
            ' B
            DoCmd.ApplyFilter "", "[Name] Like ""B*"""

the first example shows the NOT WORKING subform-syntax,
the 2nd shows the working syntax if the field [name] was in the same
form as the filter-button. I transformed it into a subform but i still
want to be able to filter it. Unfortunately it doesn't work.
can someone tell me the correct way to write the subform into that
filter-command?

thanx

oliver



Mon, 26 Feb 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Applying a filter on a form filters subforms, too

2. How to Use Access module functions via VB app with ADO

3. Deleting a Sub or Function from a Module via Code

4. filter subforms

5. Call module functions from outside of module?

6. Use of Excel functions in visual basic functions in excel module

7. Calling Function in CBF from Toolbar via a Public Function

8. Function call via string parameter in other function ?

9. Passing main module PUBLIC user-defined types (via PUBLIC Functions) in other Modules.

10. Remove filter via code

11. Email Filter Via Code

 

 
Powered by phpBB® Forum Software