CODEWITHSUNDEEP
ms-accessoffice365
Pat
Pat

Reputation: 78

Updating MS Access Query?

I'm working an Access Database for my church's local cemetery. They wanted something free, and low-to-no-maintenance, and I didn't want to go with anything online.

So I've made a sample Access Database with the fields and a simple query, checking if the field is filled out, and searching for the field if it contains something. My only problem is that, since these people want something user-friendly and easy, I can't have them right-click, close, then double click on the query every time they update the search form and click the button. What's the best way to fix this?

Again, I want to not have to quit out of and re-open the query every time I update the search form

Example Search (using random names): Every first name contains "o": https://i.sstatic.net/FhvXi.png

Example output: https://i.sstatic.net/654qJ.png

Upvotes: 0

Views: 32

Answers (1)

Rene
Rene

Reputation: 1093

Do the search in the form header and show the results in the form details.

Upvotes: 1

Related Questions