cwac60
May 21 2012, 10:34 PM
Hi Colleagues
I plan to implement filters using around 5 unbound text boxes to key in attributes on a form and once narrowed down be able to double click on a row and use id to open another form or report.
I have seen some examples for earlier versions of MS Access and would like to know if there are any enhancements in MS Access 2010 which can be exploited in either VBA or Macros.
In particular I’d like to see an example where an event is triggered with each key stroke in text box to reduce the resultant data set.
Regards
Cwac60
GroverParkGeorge
May 21 2012, 10:58 PM
You've posted this in Access reports, and specified Access 2010 web as the version. VBA is not available in Access web apps.
While the general principle of what you describe is valid, it's hard to offer more than a general comment without a bit more clarity.
Nothing that I'm aware of in Access 2010 would be any different from previous versions in this kind of filtering, though.
If you can do it in one of those previous versions, you should be able to implement it in a client database in 2010. Take one of those examples you've found and see if you can implement it.