Hello, I am unable to upload my company database so I replicate something similar (with lesser fields). My company asked me to do a search form for the database. I have done the basic search form but I need some help with the followings which I have stuck for weeks.
1) When user open the search form, I do now want to display all results in the subform before user do any search
2) Before search, user click on search button and all result will be displayed. How do I disable it (The one circle in red, in the image file)
3) I tried figuring how to allow user to search with one field and when no result found, it will prompt user that no result found.
4) Any ways to disable user from copying out the record from the search
Sorry if I ask too many questions as I am totally new to MS Access and with limited knowledge.
1) When user open the search form, I do now want to display all results in the subform before user do any search
2) Before search, user click on search button and all result will be displayed. How do I disable it (The one circle in red, in the image file)
3) I tried figuring how to allow user to search with one field and when no result found, it will prompt user that no result found.
4) Any ways to disable user from copying out the record from the search
Sorry if I ask too many questions as I am totally new to MS Access and with limited knowledge.