[Solved] Search Form ID Numbers/Text

[AmyBUK]

Hi

I'm new to Base and OpenOffice, and have been asked to create a Training Database for a colleague. I have created my tables, and I have created an input form for staff to use, which uses list boxes to ensure accurate input. The List uses the ID numbers as they are the primary keys, and then lists the text in the drop down list for ease. For example, my 'FullName' drop down has the following List Content:

SELECT "FullName", "OpID" FROM "Ops List" ORDER BY "FullName" ASC

However, I've just imported 1,800 records, and I'm finding it impossible to search for a record, as everything is logging the ID numbers (as it's supposed to).

Is there any way to search for text?

Thanks in advance for any advise or help.

[UnklDonald418]

Look at
[Example #1] Filter/Search with Forms (leveraging SubForms)
it is a long article, so scroll down near the end and download "LIKE_user_input_filter.odb"
Please let us know if you have further questions.

[AmyBUK]

Thanks That should help me perfectly.