Apply a filter to a subform

G

Guest

I ma using this code to build a filter and am not sure how to apply it to a
datasheet view subform. Can anyone help me with the syntax for that?

'draw filter criteria from open form
strCourseName = BuildCriteria("screenID", dbText, "Me!cboFilter.Column(2)")
'my failed syntax to apply filter to a second open but hidden form
Forms!frmFirstFilter.Form!tblCollection.Filter = strCourseName
 
A

Allen Browne

Try:
With Me.tblCollection.Form
.Filter = strCourseName
.FilterOn = True
End With

If that doesn't work:
1. Open the main form in design view.
2. Right-click the edge of the subform control, and choose Properties.
3. On the Other tab of the Properties box, what is the Name of the subform
control?

The Name of the control can be different from its SourceObject (the name of
the form that is loaded into the subform control).

BTW, you probably don't want to filter both the main form and the subform at
the same time. If you do that, Access is likely to get very confused when
you remove one of the filters. Details in:
Incorrect filtering of forms and reports
at:
http://members.iinet.net.au/~allenbrowne/bug-02.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter a subform from main form 2
Apply Filter to Subform 7
Concatenate criteria strings that refer to multiple fields 5
Report based on a filtered form 2
Filter 4
Can not apply filter on one or more fields specified on Filter pro 2
ApplyFilter event on a subform 1
Open a form and apply a filter to the subform 2

Top