Connecting Info from 3 forms into 1 table - Help Please

  • Thread starter Thread starter rblivewire
  • Start date Start date
R

rblivewire

I am trying to get data from 3 separate forms to display in 1 table.
The 3 forms contain separate text boxes that should connect to the one
table. The table seems to be only saving data from the first form.
Then the data from the other two froms are blank when you check the
row in the database. I am not sure if it is one of the allowedits
function or not.

Any help is appreciated
 
I am trying to get data from 3 separate forms to display in 1 table.
Click to expand...


Ummmmm... that logic is backwards.

Data is STORED in tables and DISPLAYED in forms - not vice versa!
The 3 forms contain separate text boxes that should connect to the one
table. The table seems to be only saving data from the first form.
Then the data from the other two froms are blank when you check the
row in the database. I am not sure if it is one of the allowedits
function or not.
Click to expand...

Why three forms?
What is the Recordsource property of each form?
What (if any) provision do you have to ensure that the forms are all open to
the same record?

John W. Vinson [MVP]
 
Ummmmm... that logic is backwards.

Data is STORED in tables and DISPLAYED in forms - not vice versa!


Why three forms?
What is the Recordsource property of each form?
What (if any) provision do you have to ensure that the forms are all open to
the same record?

John W. Vinson [MVP]
Click to expand...

The third point is what I am trying to achieve. I need provisions to
ensure that all 3 forms are open to the same record.

It is a program where you input variables on the first form and
second, these forms do calculations that are then input on the third
form, which is the results form.
The recordsource for each form is all to the same table. I need the
provisions mentioned in the third point.
 
The third point is what I am trying to achieve. I need provisions to
ensure that all 3 forms are open to the same record.

It is a program where you input variables on the first form and
second, these forms do calculations that are then input on the third
form, which is the results form.
The recordsource for each form is all to the same table. I need the
provisions mentioned in the third point.
Click to expand...

Again: WHY THREE FORMS?

I can't think of any calculations that would *require* separate forms.
Insisting on separate forms makes you job much harder. What *business problem*
are you trying to solve? I'm sure there's a better way.

What are the calculations? Are you trying to store the calculated values in
the table? If so here's my blurb on that practice:

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]
 
Back
Top