More Efficient Find feature in VB?

[John P]

I am a longtime FileMaker Pro user/developer converting to Access. One of the big hangups that I have is that in FileMaker Pro the find feature is much more efficient than in Access because the Access find is the basic Microsoft find. The FMP find allows for simple duplication, omits, etc., while returning all records I wish to view in the form. FMP also displays the total number of records and the number of records found, while I can only get Access to perform the Microsoft find.

A few questions...is there a way to perform a FMP-like find in Access? Should I create a "report" based on my form and perform the find there? Any advise is greatly appreciated. Thanks

 

[LarryJ]

You may want to check out filtering, instead of using the Find.

Filtered records will show you how many you have and you can save filters as queries, which you can then use for reporting and such.

So check out Filter By Selection (quick and easy) and Filter By Form (more advanced).

HTH