Populating forms from a table search

[krispetrie]

I have a combo box where I look up names. I would like to do a find on that name either in the current table(if the name exists) or in another table and populate several other fields from the table on exit.