On Wed, 17 Mar 2010 16:15:02 -0700, jwebster1979
wrote:

I have Two Tables one table has a combo box with an tblEmployeeSalary. the
other table I have is called tblSalaryHours. In tblEmployeeSalaries I have a
combo box called Salary which represents the Annual salary of the employee. I
want to use the Set Value Macro to paste that salary value in to my other in
a text box in a form called currentsalary. Any suggestions please keep it
simple and be specific as you can kind of dumb with this stuff!!

Please explain your table structure. It makes no sense to me to have a *combo
box* called Salary; salary would ordinarily be a Currency data field,
potentially different for each employee (due to raises, employment history,
grade, etc.) Where is this combo box looking up the salary FROM?

Please explain the fields in your table, and the Recordsource of the form
(open the form in design view, view its Properties, find the Recordsource
property on the Data tab; click the ... icon by it to open a query window,
select View... SQL, and post the SQL text here).
--

John W. Vinson [MVP]