I would like to have a macro set a value for a field based on a value in a table. Here are the specifics:

Use SetValue to populate field in current open form using a macro.
Have it search for a TECHID in the TECHS table based on the TECHID field from the current open form.
Once located, use the BENCH field information from the record in the TECHS table to SetValue in field.

Appreciate any help!