If you have a "table [with] a combo box", you must be using the lookup
datatype. This causes considerable confusion, since any time you look
directly in the table (probably shouldn't be doing that anyway!), what you
see in that field is NOT what Access has stored in that field.

The consensus of folks here in the newsgroups is that lookup datatypes are
confusing and cause more problems than they solve.

Besides, you really shouldn't be working directly in the tables anyway.
They may look like spreadsheets but they are NOT!

Instead, use Access queries to retrieve data from the tables and Access
forms to display it. In the form, use a combobox to look up values, storing
the looked-up value's rowID, but displaying the looked-up value.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"jwebster1979" wrote in message
...
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!!