Microsoft Access Tables and Forms

H

Helen.Dainard

I have made up a table and then created a form from it. The table does
not reflect the changes made in the form. I have done everything that
I can think of in order to make this work (input info, go to next
record, close form), but table still will not update. I want to create
reports, but I have no totals showing up, because they will not show
in the table.

Desperately in need of HELP!!!

Helen
 
J

Jeff Boyce

Helen

In a standard Access design, you create a table, (optionally, you create a
query based on the table), you create a form bound to the table (optionally,
to the query).

When you open the form in design view, one of the form's properties is the
data to which it is bound (i.e., the Control Source). If, when you created
your form, you missed this connection, your form would be unbound, and
nothing you did there would show up in the underlying table.

Can you confirm that your form is bound or not?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
M

Marco Pagliero

I have made up a table and then created a form from it. The table does
not reflect the changes made in the form. I have done everything that
I can think of in order to make this work (input info, go to next
record, close form), but table still will not update. I want to create
reports, but I have no totals showing up, because they will not show
in the table.
Click to expand...
When you open the form, does it show any record from the table? And
browse next/previous correctly?

How about the properties AllowAdditions, AllowDeletions and AllowEdits
of the form? Should be "true"

Is the property of the form RecordsetType "Snapshot" instead of
"Dynaset"?

Marco P
 
I

i_takeuti

I have made up a table and then created a form from it. The table does
not reflect the changes made in the form. I have done everything that
I can think of in order to make this work (input info, go to next
record, close form), but table still will not update. I want to create
reports, but I have no totals showing up, because they will not show
in the table.

Desperately in need of HELP!!!

Helen
Click to expand...
 
J

John W. Vinson

I have made up a table and then created a form from it. The table does
not reflect the changes made in the form. I have done everything that
I can think of in order to make this work (input info, go to next
record, close form), but table still will not update.
Click to expand...

What is the Recordsource property of the form? Does it display data from the
table?
I want to create
reports, but I have no totals showing up, because they will not show
in the table.
Click to expand...

If you're calculating totals on the Form (with textboxes with control sources
like =Sum([fieldname]) ) then those totals will not be, *and should not be*,
stored in your table AT ALL.

Storing derived data such as this in your table accomplishes
three things: it wastes disk space; it wastes time (almost
any calculation will be MUCH faster than a disk fetch); and
most importantly, it risks data corruption. If one of the
underlying fields is subsequently edited, you will have data
in your table WHICH IS WRONG, and no automatic way to detect
that fact.

Just redo the calculation whenever you need it, either as a
calculated field in a Query or just as you're now doing it -
in the control source of a Form or a Report textbox.

John W. Vinson [MVP]
 
Top