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]