Filtering Question

  • Thread starter Thread starter Nathan Guill
  • Start date Start date
N

Nathan Guill

I'm not sure if this is the correct forum, but I am searching for an example
of how to perform an MS Access "filter by form" style query. In other
words, I want the user to click on the "Filter" button and the UI controls
would blank out to accept the user's input. When the user hit OK, the query
would run using only the fields the user entered.

Any help would be appreciated.
 
If you bind to a dataview object, then you can just figure out what columns
were selected (I think you'll have to so to the UI for that) and set the
Rowfilter property accordingly. There's a few ways to filter
(DataTable.Select, Find) but the approach is all the same)
 
Thanks for this, but I am not using a dataview object. I have a collection
of textboxes, comboboxes, radioubutton, etc. that displays the data to the
user. What I need is something similar to MS Access.
 
Back
Top