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?
Marc - 17 Jun 2004 03:28 GMT
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
> 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
[quoted text clipped - 5 lines]
> when I click on Find Next, nothing happens. No error
> message, no nothing. What is wrong?
Suze - 17 Jun 2004 06:32 GMT
>-----Original Message-----
>I have set up a command on a form to search a table and
[quoted text clipped - 9 lines]
>.
>The Find box is set to Any part of field, which I did in
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 ???