A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old December 15th, 2006, 08:42 PM posted to microsoft.public.access.forms
[email protected]
external usenet poster
 
Posts: 37
Default 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  
Old December 15th, 2006, 09:27 PM posted to microsoft.public.access.forms
Klatuu
external usenet poster
 
Posts: 7,074
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.