Add new field to table linked to subreport

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am brand new to this. I created a table then a subform from that table.
The users then decided to add a field to determine if the customer sent in a
stamped envelope. I added a field to the subform, and one to the table (both
Yes,No lists)
but when I enter yes/no into the subform it doesn't carry over to the table.
How do I get the into to populate the table from the subform?
 
On your subform you need to make the control bound to the field on the table.
Go to the Properties window for your control, and on the "data" tab, the
first field is "Control Source." Assuming your subform is properly bound this
will be a dropdown list that you can select the correct fieldname from.

Hope this helps!

Theo Geer
 
Thank you Theo
I did what you suggested but now when I try to enter data (Yes/No) in the
subform it won't let me. The Yes/No list drops down but when I choose yes or
no I get a tone.
 
Is the field in your table a yes/no field? - If so this is your problem. Make
your control a check-box instead of a drop-down menu.

Theo
 
If your field in the table is already a yes/no (as I suspect it is) then you
shouldn't need to change the table. Just make a control on your form as a
checkbox and set the control source to your field. Don't forget to delete the
combo-box you were using for the field.
 
I changed the field in the table to Yes/No instead of a look up table, I
changed the properties in the subform to control source [Mailing
List]!Envelope, the Row source type to Table/Query, and the row source to
Mailing list, and now when I try to enter into the subform field it just
lists #Name# and won't let me input anything.
 
Elaine,

The control on the SubForm needs to be a Check Box.

1) Delete the current control.
2) Open the forms field-list (view-->Field List)
3) Drag the name of your field from the Field List to the Form.
4) Just format/arrange the form how you need it.

Elaine said:
I changed the field in the table to Yes/No instead of a look up table, I
changed the properties in the subform to control source [Mailing
List]!Envelope, the Row source type to Table/Query, and the row source to
Mailing list, and now when I try to enter into the subform field it just
lists #Name# and won't let me input anything.

Theo Geer said:
Is the field in your table a yes/no field? - If so this is your problem. Make
your control a check-box instead of a drop-down menu.

Theo
Click to expand...
Click to expand...
 
That seems to be my problem, the field name Envelope isn't there on the Field
Name list, even though I added it in it is just listed as check box 48. is it
because it wasn't on the original table?

Theo Geer said:
Elaine,

The control on the SubForm needs to be a Check Box.

1) Delete the current control.
2) Open the forms field-list (view-->Field List)
3) Drag the name of your field from the Field List to the Form.
4) Just format/arrange the form how you need it.

Elaine said:
I changed the field in the table to Yes/No instead of a look up table, I
changed the properties in the subform to control source [Mailing
List]!Envelope, the Row source type to Table/Query, and the row source to
Mailing list, and now when I try to enter into the subform field it just
lists #Name# and won't let me input anything.

Theo Geer said:
Is the field in your table a yes/no field? - If so this is your problem. Make
your control a check-box instead of a drop-down menu.

Theo

:

Thank you Theo
I did what you suggested but now when I try to enter data (Yes/No) in the
subform it won't let me. The Yes/No list drops down but when I choose yes or
no I get a tone.

:

I am brand new to this. I created a table then a subform from that table.
The users then decided to add a field to determine if the customer sent in a
stamped envelope. I added a field to the subform, and one to the table (both
Yes,No lists)
but when I enter yes/no into the subform it doesn't carry over to the table.
How do I get the into to populate the table from the subform?
Click to expand...
Click to expand...
Click to expand...
 
Elaine,

If your form is bound to the table the new field will show up in the field
list. Please note, the field list is not the same as the drop-down box in the
control-properties window. The field list is a small pop up that displays the
fields in the table the form is linked to. If the form is bound to the table,
and the field is in the table, then the field will be in the field list.

To access the field list:

1) open the form in design view
2) Click on View in the menu bar
3) Select 'Field List'



Elaine said:
That seems to be my problem, the field name Envelope isn't there on the Field
Name list, even though I added it in it is just listed as check box 48. is it
because it wasn't on the original table?

Theo Geer said:
Elaine,

The control on the SubForm needs to be a Check Box.

1) Delete the current control.
2) Open the forms field-list (view-->Field List)
3) Drag the name of your field from the Field List to the Form.
4) Just format/arrange the form how you need it.

Elaine said:
I changed the field in the table to Yes/No instead of a look up table, I
changed the properties in the subform to control source [Mailing
List]!Envelope, the Row source type to Table/Query, and the row source to
Mailing list, and now when I try to enter into the subform field it just
lists #Name# and won't let me input anything.

:

Is the field in your table a yes/no field? - If so this is your problem. Make
your control a check-box instead of a drop-down menu.

Theo

:

Thank you Theo
I did what you suggested but now when I try to enter data (Yes/No) in the
subform it won't let me. The Yes/No list drops down but when I choose yes or
no I get a tone.

:

I am brand new to this. I created a table then a subform from that table.
The users then decided to add a field to determine if the customer sent in a
stamped envelope. I added a field to the subform, and one to the table (both
Yes,No lists)
but when I enter yes/no into the subform it doesn't carry over to the table.
How do I get the into to populate the table from the subform?
Click to expand...
Click to expand...
Click to expand...
 
Theo
Now we are at the root of my problem I think. The new field "envelope" is
not included in the field list, all of the original fields are there ( the
ones I created the form with from a form wizard) so how do I get the field
list to recognize the new field "envelope"?
Thanks
 
Elaine said:
Theo
Now we are at the root of my problem I think. The new field "envelope" is
not included in the field list, all of the original fields are there ( the
ones I created the form with from a form wizard) so how do I get the field
list to recognize the new field "envelope"?
Thanks
Click to expand...
 
Theo
I got it to work, Thank you soo much. I went into the froms poperty and
added the envelope field. I then went into the form design and added a check
box, dragged the envelope to it from the field list just like you said. and
it works.

Elaine

Theo Geer said:
Elaine,

If your form is bound to the table the new field will show up in the field
list. Please note, the field list is not the same as the drop-down box in the
control-properties window. The field list is a small pop up that displays the
fields in the table the form is linked to. If the form is bound to the table,
and the field is in the table, then the field will be in the field list.

To access the field list:

1) open the form in design view
2) Click on View in the menu bar
3) Select 'Field List'



Elaine said:
That seems to be my problem, the field name Envelope isn't there on the Field
Name list, even though I added it in it is just listed as check box 48. is it
because it wasn't on the original table?

Theo Geer said:
Elaine,

The control on the SubForm needs to be a Check Box.

1) Delete the current control.
2) Open the forms field-list (view-->Field List)
3) Drag the name of your field from the Field List to the Form.
4) Just format/arrange the form how you need it.

:

I changed the field in the table to Yes/No instead of a look up table, I
changed the properties in the subform to control source [Mailing
List]!Envelope, the Row source type to Table/Query, and the row source to
Mailing list, and now when I try to enter into the subform field it just
lists #Name# and won't let me input anything.

:

Is the field in your table a yes/no field? - If so this is your problem. Make
your control a check-box instead of a drop-down menu.

Theo

:

Thank you Theo
I did what you suggested but now when I try to enter data (Yes/No) in the
subform it won't let me. The Yes/No list drops down but when I choose yes or
no I get a tone.

:

I am brand new to this. I created a table then a subform from that table.
The users then decided to add a field to determine if the customer sent in a
stamped envelope. I added a field to the subform, and one to the table (both
Yes,No lists)
but when I enter yes/no into the subform it doesn't carry over to the table.
How do I get the into to populate the table from the subform?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top