Search does not work when in Forms

  • Thread starter Thread starter KC
  • Start date Start date
K

KC

Whenever I am in a Form and I want to search for a
particular record that contains a person's name (for
example), I receive a message that that record does not
exist in the database. I make sure that the "Look in"
field has the entire form selected and NOT any one
particular field. The "Match" field is set to look
in "any part of field." And the "Search" field is set
to "all".

I can manually navigate to the particular record that I am
interested in if necessary.

What is strange, is that if I go into the table, I can
find the record no problem.

Any ideas?
 
Has the form been filtered? What does the record counter on
the nav bar read?
 
KC said:
Whenever I am in a Form and I want to search for a
particular record that contains a person's name (for
example), I receive a message that that record does not
exist in the database. I make sure that the "Look in"
field has the entire form selected and NOT any one
particular field. The "Match" field is set to look
in "any part of field." And the "Search" field is set
to "all".

I can manually navigate to the particular record that I am
interested in if necessary.

What is strange, is that if I go into the table, I can
find the record no problem.

Any ideas?
Click to expand...

Is that field in the table set up as a Lookup field by any chance? In that
case what the table has stored in it is NOT what you see in your form or
table and that is why the search doesn't find it.
 
KC said:
Whenever I am in a Form and I want to search for a
particular record that contains a person's name (for
example), I receive a message that that record does not
exist in the database. I make sure that the "Look in"
field has the entire form selected and NOT any one
particular field. The "Match" field is set to look
in "any part of field." And the "Search" field is set
to "all".

I can manually navigate to the particular record that I am
interested in if necessary.

What is strange, is that if I go into the table, I can
find the record no problem.

Any ideas?
Click to expand...

Do you also have the "Search fields as formatted" box checked? If not,
try that.
 
Back
Top