value appears in form, not in table

  • Thread starter Thread starter Gretchen
  • Start date Start date
G

Gretchen

Greetings! I have a datasheet view subform that has a
field that is populated based on another field.

On the subform, it looks as though each entry contains
the populated value (say I have 4 instances). However,
when I look at the table, only the first instance (from
the datasheet) has the value and all other instances have
no value stored in that field in the table. I do want to
store the value in the field.

I don't understand why this is happening and hope someone
can explain and perhaps offer an alternative. Thank you.
 
Yes, it is. The value that I need is on the main form,
and the value I'm "copying" to is on the subform of a
form on the main form. Thank you.
 
The reason why I ask is if you go to the underlying query and see the same 4
records it will rule out the sub form.

I have a hunch thet query has a join between 1 or more tables and the data
is being repeated 4 times. For example, a missing link will multiply out the
rows.


Table A TableB
1 1
2 4
3
4

Joining these correctly will give 2 unique rows. Miss out the join and
you'll get 8
 
Back
Top