I need to create a search button for my database so that I can enter a surname and have it open a form with only that record in it. I don't want to use a combo box because I don't want users to be able to see all the surnames. Help?
ANSWERS: 1
Sort by: Highest Rated
-
There is already a search button on the Form View toolbar - it looks like a pair of binoculars. Select the field that you want to search and click on it. You can duplicate the button on your form using a command button. To filter the data to show only the surname you need use the toolbar Filter by Form and Apply Filter buttons. You can duplicate these buttons on the form itself by using two command buttons, but I think your users would find that more complicated than using the toolbar buttons.
-
No comments
RELATED QUESTIONS
RELATED TOPICS
ABOUT ANSWERBAG
Answerbag wants to provide a service to people looking for answers and a good conversation. Ask away and we will do our best to answer or find someone who can.We try to vet our answers to get you the most acurate answers.
Copyright 2023, Wired Ivy, LLC