Forum Discussion
Filter a form with a button (subform)
Thanks for the additional information. The screenshot showed only the filter on the datasheet view, so I misinterpreted the situation. Yes, that does make it possible.
I would actually use a combo box, rather than a command button, though, because the button still has to have a value on which to filter and that has to come from somewhere.
In fact that is a very standard approach to making forms more efficient by limiting records in a form's recordset. That's crucial to working with remote databases, such as SQL Server.
The attached demo is intended for a very different purpose, but the combo box to filter a recordset in a subform is pretty much the same as what you need and can be adapted.
That is a built-in function of the datasheet view of a form, so replicating it is going to require a different approach. That said, " I want to use a button for this now to be more efficient." raises the question, What inefficiencies have you encountered?
Other relevant details might include, when you create this button, where will it be? Datasheet view doesn't support that, as far as I can tell.
On the other hand, you could create a similar form in Continuous View and put filtering command buttons on it instead.
- Hi George,
My unbound form is actually in form view and this is where the button would be placed...not in the subform that is in datasheet view (this is the subform to filter). What I mean by more efficient is that is quicker to press a button than to click the filter icon and then click again the item you want to filter out of all the choices available. Let me know if that changes anything. thank you.Thanks for the additional information. The screenshot showed only the filter on the datasheet view, so I misinterpreted the situation. Yes, that does make it possible.
I would actually use a combo box, rather than a command button, though, because the button still has to have a value on which to filter and that has to come from somewhere.
In fact that is a very standard approach to making forms more efficient by limiting records in a form's recordset. That's crucial to working with remote databases, such as SQL Server.
The attached demo is intended for a very different purpose, but the combo box to filter a recordset in a subform is pretty much the same as what you need and can be adapted.
- Thank you George. Little above my head but I will see if I can get it to work.
