Filter By Form disables all controls

[bronc]

I place a button on a form to make a filter using

DoCmd.RunCommand acCmdFilterByForm

After choosing the filter by checking the boxes etc I would then like to Apply the filter using

DoCmd.RunCommand acCmdApplyFilterSort

in another button or checkbox or whatever. The only problem is that it seems all buttons etc are disabled (except of course the controls which are bound to the data)on the Filter by Form form. I don't want to use a menu or toolbar toggle I wish to do it from the form.

 

[lameid]

DoCmd.RunCommand acCmdApplyFilterSort

That is a new one to me but it looks like it should turn the filter of the form on like running...

Me.Filteron = True

That line is almost always preceded by a line that sets the filter...

Me.Filter = "ID = 5"
Me.Filteron = True

The example above filters the form to ID to 5.

I hope this gets you where you want.

 

[bronc]

There's no need to set a filter in code. Filter is set implicitly when using the Filter by Form. Of course Filteron = True is an alternative but that is not what I was enquiring of.

The question I was posing is how do to place code in a control when all of the controls are going to be disabled when Fiter by Form is implemented.

 

[TheAceMan1]

How are ya bronc . . .

[blue]FilterByForm[/blue] disables all unbound controls so there not accidently included in the filter. This would raise an error! ...

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]