Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / May 2007

Tip: Looking for answers? Try searching our database.

Connecting Info from 3 forms into 1 table - Help Please

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
rblivewire@hotmail.com - 03 May 2007 03:17 GMT
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
John W. Vinson - 03 May 2007 05:33 GMT
>I am trying to get data from 3 separate forms to display in 1 table.

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.

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]
rblivewire@hotmail.com - 03 May 2007 06:02 GMT
On May 3, 12:33 am, John W. Vinson
<jvinson@STOP_SPAM.WysardOfInfo.com> wrote:

> >I am trying to get data from 3 separate forms to display in 1 table.
>
[quoted text clipped - 14 lines]
>
>              John W. Vinson [MVP]

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.
John W. Vinson - 03 May 2007 06:12 GMT
>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.
[quoted text clipped - 4 lines]
>The recordsource for each form is all to the same table. I need the
>provisions mentioned in the third point.

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]
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.