Accidently posted this in the wrong forum...sorry


Fairly new to the Access world and this is one I just cannot figure out


Have an unbound form with a combobox (CBOName) bound to employees table

(for name lookup)
8 of the textboxes are bound to this combobox and pull address, city
state etc...for viewing purposes. The only non-viewing textbox is;
(TXTEmpID) this contains the employee number which I will need to pass
on later. I have no problems getting this data from the table.


Now comes the fun part...
I need to pass TXTEmpID data to a new table...named equipment. This
will be the number I will use in my queries...
Second problem is; I have 17 radio(option) buttons and 16 additional
textboxes that the user will fill out and it to be entered into the
equipment table. The option buttons aren't really a boolean type of
button. I set each one up individually because an employee could be
shipped multiple items.
I have tried binding the form to the equipment table, but my data from
the employees table gets corrupted. Tried unbinding it and cannot get
it to work


What is my best option here? I have looked around and have not quite
found what I am looking to do.


Thanks


Hans