[SOLVED] Use Find Record (Binoculars) on a listbox

[cazbym]

I have searched the forums but cannot seem to find an answer to this one.

I have a table with two fields ID (PK) and Name (VARCHAR).

I have a form with a table control displaying just ONE listbox based on SQL - Name , ID, which displays all the Names. (The ID field is required as it is picked up by a macro which then opens and filters another form based on another table.

My problem is - is it possible to use "Find Record" to search through the listbox. I have been trying to find "Fred Bloggs", but it says no records match, because presumably it is actually searching the ID field.

[Billyray]

Can you sort the Name alphabetically, then use a combo box? Then you can start typing the name and it will automatically fill in the rest of the name. (find the record) I'm doing that with a large list of names.
_________________
Billyray
using:
Linux distro: Ubuntu 10.04 LTS, Lucid Lynx, OOo Base 3.3, connected to MySql database using Java jdbc (note: ONLY sun-java-6-1.6.0_22 jre works right), and converted from MS Access 2003.

[dacm]

[cazbym]

Thanks for responses - the answer for me was to check the "apply field format" in the "find record" options. Thought I had already tried that before but apparently not.