Use the Find Method to offset an populate TextBox controls.
http://www.ozgrid.com/VBA/find-method.htm

Failing that, use Excels built in Data Form.

Failing that;
http://spreadsheetpage.com/index.php/dataform/home/


--
Regards
Dave Hawley
www.ozgrid.com
"Tomwireless" wrote in message
...
I Have 2 sheets, a database of items sheet and a form with a combo box to
put
the record I get from the database. I want to pick a record from the
database, and add it to my form and have it bring the WHOLE record with it
to
the form not just the combo box cell. Both sheets have the same field
names
in them.

anyone have an idea on this?

Tom
--
Thank you