Need help on Form with Combobox and mutiple textboxes, option buttons

[hansjhamm]

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

 

[Guest]

I think you need a form/subform setup. The form should have the employee
table as its record source and the subform will have the equipment table as
its source.
Since the employee number is used in the equipment table, that is the field
you will want to use for the Link Master Field and Link Child Field
properties of the subform control.