Fitler Subform

[fpendino]

It's been a while since using Access. Been doing ASP.net and SQL. I have a form with a subform. I'm trying to filter the subform which is disabled, with the value from a listbox.

On the double click of the listbox I have... frmTeamEdit is the subform

Forms!frmTeamMaintenance!frmTeamEdit.Form.Filter = "[TeamID] = " & Me.lstTeams
Me.frmTeamEdit.Enabled = True
Me.frmTeamEdit.Form.DataEntry = False

It is displaying only the first record in the table. It's showing the filter in the property window, but is not actually filtering.

Thanks in advance!

 

[fpendino]

Nevermind, I just changed the Recordsource of the form instead

 

[boblarson]

You COULD have gotten it to work if you just added one line:

Forms!frmTeamMaintenance!frmTeamEdit.Form.Filter = "[TeamID] = " & Me.lstTeams
Forms!frmTeamMaintenance!frmTeamEdit.Form.FilterOn = True

 

[Rich]

Unless it's been changed in newer versions filtering the subform via vba doesn't work as expected

 

[boblarson]

Unless it's been changed in newer versions filtering the subform via vba doesn't work as expected

I've had it working great with no problems (Access 2000, 2003)

 

[Rich]

You cannot use the ApplyFilter action to apply a filter to a subform. If
you try to do so, the filter is applied to the main form instead. In
Microsoft Access version 1.x, you can achieve some of this functionality

by basing the subform on a parameter query. In the other versions of
Microsoft Access, you can get the same results by changing the subform's
RecordSource property.



Copyright (c) Microsoft Corporation. All rights reserved.

I guess it's time for an upgrade

 

[boblarson]

You cannot use the ApplyFilter action to apply a filter to a subform. If
you try to do so, the filter is applied to the main form instead. In
Microsoft Access version 1.x, you can achieve some of this functionality

by basing the subform on a parameter query. In the other versions of
Microsoft Access, you can get the same results by changing the subform's
RecordSource property.



Copyright (c) Microsoft Corporation. All rights reserved.

I guess it's time for an upgrade

But, while you can't use DoCmd.ApplyFilter you CAN use:

Forms!YourMainform.YourSubformContainer.Form.Filter = "Whatever"
Forms!YourMainform.YourSubformContainer.Form.FilterOn

and THAT works.