Not all fields get added to table

[JUAN]

Hello,
hope I can get some help. I have a form based on a table
PROD_GROUPS so that I can add records to this table.
Not all fields get added to the table only some. Here's my
form:
FCODE3:FCODE3 (Controlsource
MAT_GROUP:MAT_GROUPS (Controlsourcr
FCODE2:FCODE2 (This is a combo box, that when user selects
from here, then it will fill the other text boxes. First I
made this an UNBOUND, and then I put controlsource FCODE2
TBOX1:=[Combo22].[Column](2) in controlsource
TBOX2:=[Combo22].[Column](3) in controlsource
TBOX3,TBOX4, etc.
The first three fields get added to my table but the
fields in the text boxed don't. So not sure if I'm doing
somethign wrong. I guess it has to do with the
controlsource.
Please advise any info. really appreciate it.
Thanks,

Juan

 

[Rick Brandt]

Hello,
hope I can get some help. I have a form based on a table
PROD_GROUPS so that I can add records to this table.
Not all fields get added to the table only some. Here's my
form:
FCODE3:FCODE3 (Controlsource
MAT_GROUP:MAT_GROUPS (Controlsourcr
FCODE2:FCODE2 (This is a combo box, that when user selects
from here, then it will fill the other text boxes. First I
made this an UNBOUND, and then I put controlsource FCODE2
TBOX1:=[Combo22].[Column](2) in controlsource
TBOX2:=[Combo22].[Column](3) in controlsource
TBOX3,TBOX4, etc.
The first three fields get added to my table but the
fields in the text boxed don't. So not sure if I'm doing
somethign wrong. I guess it has to do with the
controlsource.
Please advise any info. really appreciate it.
Thanks,

A Control is *either* bound (so it will save values to the table) or it uses an
expression (like =[Combo22].[Column](2)). It cannot do both at the same time.
Think of it this way. The field that the data gets saved to is the field name
entered in the ControlSource of the control. Therefore if you enter anything in
the ControlSource that is NOT a field name then there is no way for the control
value to get saved.

The good news is that you really don't have a problem because you shouldn't be
storing these other values anyway. If they can be retrieved from another table
via the ComboBox then they have already been saved once and that is all that is
required. Just pull them from that other table whenever you need them.