If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need help on Form with Combobox and mutiple textboxes, option buttons
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 |
#2
|
|||
|
|||
Need help on Form with Combobox and mutiple textboxes, option butt
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. " wrote: 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 |
Thread Tools | |
Display Modes | |
|
|