cannot use find functionality

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

problem description:
open a form and press control -f (find) I type in "HOU" and select search entire form and match any part of field. I press go and get this error message: "you cannot search filed for specified value. resolve error given in previos error message"

what does that error message mean and how do i resolve this. I want to search all field and records that have HOU string.
 
problem description:
open a form and press control -f (find) I type in "HOU" and select search entire form and match any part of field. I press go and get this error message: "you cannot search filed for specified value. resolve error given in previos error message"

what does that error message mean and how do i resolve this. I want to search all field and records that have HOU string.
Click to expand...

It sounds like you may be trying to search a Lookup field. Right?

If so, be aware that the Lookup field type is generally considered an
obnoxious misfeature, for this reason among many others. What you SEE
is a text string which might or might not contain "HOU", but what's
stored in the table (and what Find will search) is the concealed
numeric ID linking to the Lookup table.

Try opening the table in design view, selecting this field, and
changing the Lookup tab from "combo" to "textbox" to see if this is
the case. If it is, create a Query linking the two tables and do your
searching there.
 
Back
Top