DATA INPUT USING FORMS BUT NOT SAVING

  • Thread starter Thread starter Nannap
  • Start date Start date
N

Nannap

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?
 
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
 
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
 
In the second subform, I have a lookup of a query
with the bound column and 3 column counts.
Click to expand...

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