O
onlyalackey
I add data in Forms field but data does not show up in Table field with same
name nor in any reports.
name nor in any reports.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Why is my table field not updated when I add data in form field?
J
Jeff Boyce
Does the Form know that it is connected to (bound to) the Table?
Is there a chance that the data IS going into the Table, just not where you
expect to see it? (you can test for this with a query).
Is there a chance that the data IS going into the Table, just not where you
expect to see it? (you can test for this with a query).
O
onlyalackey
Jeff:
I am afraid I do not know what "bound" means or how to check it. The whole
problem started when i tried to use DateADD function in Tables as a Default
Value for a field, got an error message, went to Forms and was able to use
DateADD there but the same named field in Tables is not updated.
Thanks
Bob
I am afraid I do not know what "bound" means or how to check it. The whole
problem started when i tried to use DateADD function in Tables as a Default
Value for a field, got an error message, went to Forms and was able to use
DateADD there but the same named field in Tables is not updated.
Thanks
Bob
J
Jeff Boyce
Bob
"Bound" means the form "knows" what set of data it's referring to. You can
make a form without giving it any data source, but it won't be "bound" to
any data source!
If you open your form in design mode and check its properties, the
RecordSource property tells you what the form is bound to.
I don't understand why you were trying to use the DateAdd() function in your
table ... does this mean you wanted to take some other field's value and
store a calculated value based on it? (This isn't a good idea, usually).
You can do whatever you want to the controls on a form, but that doesn't
change the table's definition.
"Bound" means the form "knows" what set of data it's referring to. You can
make a form without giving it any data source, but it won't be "bound" to
any data source!
If you open your form in design mode and check its properties, the
RecordSource property tells you what the form is bound to.
I don't understand why you were trying to use the DateAdd() function in your
table ... does this mean you wanted to take some other field's value and
store a calculated value based on it? (This isn't a good idea, usually).
You can do whatever you want to the controls on a form, but that doesn't
change the table's definition.