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 / April 2008

Tip: Looking for answers? Try searching our database.

DATA INPUT USING FORMS BUT NOT SAVING

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Nannap - 10 Apr 2008 10:09 GMT
Hi

Can anyone tell me what I am doing wrong.  I have set up a database with the
main form have 2 subforms.  In the second subform, I have a lookup of a query
with the bound column and 3 column counts.  This all works ok and the
information I required is visible in the subform and the same for the 3
subform, but when I close the form only the field with the lookup is saved in
the table - not the 3 extra columns.  Do I do a setvalue in the properties or
what?
Jeanette Cunningham - 10 Apr 2008 12:18 GMT
Nannap,
those 3 extra columns should be fields in your table.
Each text box should have as its data source, one of the fields in the
table.
When you type a value in each text box, the value you typed will be saved in
the table.

Jeanette Cunningham

> Hi
>
[quoted text clipped - 9 lines]
> or
> what?
Nannap - 10 Apr 2008 12:52 GMT
Yes, there are corresponding fields in the tables, but they are not saving!

> Hi
>
[quoted text clipped - 5 lines]
> the table - not the 3 extra columns.  Do I do a setvalue in the properties or
> what?
Jeanette Cunningham - 10 Apr 2008 13:06 GMT
OK,
we will need more info to be able to help you.
Names of the 3 tables
For each table its primary key
The names of the foreign keys
The relationships between the tables.

Jeanette Cunningham

> Yes, there are corresponding fields in the tables, but they are not
> saving!
[quoted text clipped - 12 lines]
>> properties or
>> what?
John W. Vinson - 10 Apr 2008 17:36 GMT
> In the second subform, I have a lookup of a query
>with the bound column and 3 column counts.  

If you're trying to store COUNTS in your table... don't.

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.
Signature


            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.