If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I create a search button on a form-db is large
I have a db of student records that contains two tables. A form is used for
adding and editing records and it would be great if I could add a search feature. I am working on a switchboard that, in this early stage, just allows users to view records by form of current students or prospective students. I created a parameter query that permits a user to access records by entering last name, however; I want a more sophisticated method, such as a search button when the forms open. Thanks, angie |
#2
|
|||
|
|||
How do I create a search button on a form-db is large
Angie,
One common way to do this is to put a combobox in your form header that would list your students alphabetically and allow you to select the student and have the form then show that person's record. If this is would fit the bill for you, turn your toolbox wizard on and drop a combobox in the form header. As you work through the wizard one of the options will be to " Find a record on my form based on the value I selected in my combo box ". If you select this option it will then give you choices of what to look up by. A common approach here would be to actually look up by StudentID, but to collapse that field to 0 width and then display student name in the second column this allows you to type in the student name and have the field autofill as it is typed. If you concantenate the student's last and first names in the underlying query for the form it would be ideal as you could then type in "Sm" and get "Smith, Joe" followed by "Smith, Thomas". If your underlying records have more than one record per student, you will find that the student is listed more than once in the list. -- Gary Miller Sisters, OR ________________________ "Angie L." wrote in message ... I have a db of student records that contains two tables. A form is used for adding and editing records and it would be great if I could add a search feature. I am working on a switchboard that, in this early stage, just allows users to view records by form of current students or prospective students. I created a parameter query that permits a user to access records by entering last name, however; I want a more sophisticated method, such as a search button when the forms open. Thanks, angie |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Search facility | tezza | General Discussion | 13 | February 18th, 2010 12:26 AM |
command button wizard not showing matching field | zmas via AccessMonster.com | Using Forms | 0 | October 6th, 2005 07:54 PM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
Copy form data to a table | Gunner | General Discussion | 5 | January 24th, 2005 08:53 PM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |