Forum Moderators: open

Message Too Old, No Replies

Search button for a Microsoft Access 2003 Form

Because ver 2003 doesn't have the easy search functionality of ver 2007

         

picophd

12:16 pm on Mar 6, 2007 (gmt 0)

10+ Year Member



Hi. I'm still a beginner at Microsoft Access & databases generally. Is there a fairly straightforward & understandable method of adding a Search button to a Microsoft Access 2003 Form, which can allow the user to search 2 main tables used in that Form?

I really like the search functionality implemented near the record numbers at the bottom of a Form in Microsoft Access 2007, but unfortunately, I can only use version 2003 at work. This is why I need to implement the search button.

I know I can use Ctrl+F, but I need a conveniently located and properly customized button in the Form itself for others who may need to update the database or retrieve information from it and who may be newbies or easily intimidated by computers.

The button needs to search two specific main tables, any part of any field. If I should supply any more details about the database, please let me know.

Many thanks for anyone taking the time to help & give tips.