search a record

is there a way to do something like a 'binocular' button found in access 2000 ?
In access, there is this 'binocular' control when click, it pop a dialogbox prompting to search by whichever field the cursor is last placed on.

You could get similar functionality by creating a search form (for the user to input criteria) and using either the ADO Find method or DAO's FindFirst/FindNext methods on their recordset objects.

Paul

This is a very old post but I didn't wanted to create a stir by creating another thread.

I have 3 textboxes:

Name.Text
School.Text
SS.Text

1) What if I did a search using "FindFirst" and I discover that there are two students with the same name. How can I display both records or allow the user to display all matching entries.

2) This may be a dumb question. Is it possible to have duplicated names if "Name.Text" is a primary key.

I realize that this is an old post but I didn't wanted to create a stir by creating a new on.

A couple of questions:
1) If I used "FindFirst," how can I display all matching entries. For example, I have a total of 3 text boxes. I search one of them and disover that there are two similar record. How can display them.

2) If one my field is a primary key, is it possible for me to have a duplicated value for that field.

Thanks a bunch!

In general, we strongly recommend you start new threads than to
reopen an old one.

If you have the name field as the primary key, it won't allow
duplicates. This probably isn't very practical as names are many
times duplicated. FindFirst only finds the first match. You would
have to use other methods to find all matches. My preference is
always to select the records I want to work with, rather than to
just populate a recordset with all records in a table and then use
searches on that recordset.