Find command

S

Suze

I have set up a command on a form to search a table and
find a record. The data is peoples names who each have
their own number. Obviously I want to be able to find
people by their name if their number is not known. The
problem I am having is that when I type a persons name
in, it brings up the first match and even though I know
there are more people in the table with the same name,
when I click on Find Next, nothing happens. No error
message, no nothing. What is wrong?
 
M

Marc

Hi Suze,
If the whole name in the field?
in the find and replace box change the Match from whole field to any part of
the field.
Marc
 
S

Suze

-----Original Message-----
I have set up a command on a form to search a table and
find a record. The data is peoples names who each have
their own number. Obviously I want to be able to find
people by their name if their number is not known. The
problem I am having is that when I type a persons name
in, it brings up the first match and even though I know
there are more people in the table with the same name,
when I click on Find Next, nothing happens. No error
message, no nothing. What is wrong?

.
The Find box is set to Any part of field, which I did in
Click to expand...
the Options, Find/Edit. This command did work fine, but
now doesn't. I may be better deleting the command putting
new one in place ???
 
Top