I want all the available results to the listbox and display the info of chosen company (which I already got it working from another form)
It's keep showing "Runtime Error-91 Object variable or with block not set"
Also, how can I search only a part of field (ie. I search for Nacho and there are two customer's with Nacho in it 1) Nacho's Place 2) Tacho Nacho) instead of getting the exact valid name?
Instead of opening a recordset, (Which, BTW, I'm not sure you've done...) and searching the recordset, let SQL do the work for you.
Open a recordset with the search criteria being used in the SQL query, and then, if the rs ie empty, either rs.addnew, or, use SQL to INSERT a new record directly.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert