How do I create a search button on a form-db is large

[Guest]

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

 

[Gary Miller]

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
________________________
message
news:[email protected]...