I have created a form to record any stock borrowed from another department. The item_desc record is a combo box. How can I search the description field in the combo box for a word in any part of the field? eg look for "survac" ('cause you don't know that it is a type of drain & stock list has it as Drain - Survac - complete unit). When I created a macro to find a word, it looked only at previous records for the department, not the combo box. I think it needs some code, but I don't know VB or SQL well enough.
HELP! (I have created a temporary solution by going to a form which runs a query with the parameter Like * & [Enter word you are searching for] & *. But then once you have found the exact description, you have to close the form & find the same description in the combo box - a bit messy!)


[This message has been edited by FionaC (edited 03-20-2000).]