MY FORM IS NOT UPDATING MY TABLE

[Guest]

I have a form based on 3 tables. One table has all member information. One
has member gains and losses from year 2005. One is blank for the member gains
and losses this year 2006. All the tables are related by the member number in
each table. The form pulls the member information and membership total from
year 2005 correctly. But when I add the gains and losses for this year 2006,
it is not putting the gains and losses numbers in this year 2006 table. Does
anyone have any suggestions as to why it is not putting the information from
the form into the table? Thanks in advance for your help.

 

[Tony Vrolyk]

I think the problem might be from storing similar information in two
different tables. From your description is sounds like the Member gains 2005
are the same type of data as the Member Gains 2006 but are stored in a
different table. It might be better to put all Member Gains & Losses into a
single table and put a date with each record so you know what year it
applies to. Or if the exact date is not necessary, then just a 4 character
text field that store the year it applies to. Otherwise every year you will
be building new tables and that could get out of hand.

You may want to read up on normalization. It is a set or rules that explain
how data should be organized in a relational database. Search google on
previous posts on teh subject and you should find some good info.

If the separate tables are required than make sure the fields are bound to
the correct table. Assuming the 2005 and 2006 are the same and have fields
named the same then your fields need to be bound to the correct table.

Lets say your tables are named GainsLosses2005 and GainsLosses2006 and they
both have a field called ChangePercentage. then the field for 2006 should be
bound to [GainsLosses2006].[ChangePercentage]. The brackets may not be
necessary. Look at the underlyiung query and view its results and check the
column headings to get the exact field names.

Tony V