Data in subform not appearing in underlying table

[Guest]

I have a form with 5 subforms (set up as tab pages).

I am having an issue with one field on one of the subforms. The subforms
are in a one to many relationship with the main form. The Primary Key on the
Main Form is the Foreign key on the subform. All subforms are created off a
query. On the subform with the problem, there are 3 tables used in the query
to create the subform.

When I make an entry into one of the fields on the subform, it appears on
the subform. I can switch to another record and come back, it still appears
on the subform. However, the data is not being written to the underlying
table. The field with the problem was added recently.

I am not sure what the problem is. I have had no such problems with this
subform in the past (or any of my other subforms). I have tried playing with
the data entry property and have looked at the dynaset property...but I still
can't get the data to be written to the underlying table.

Any suggestions?

Thank you,
Dawn

 

[jahoobob via AccessMonster.com]

Try setting the recordset type property of the subform to Dynaset
(Inconsistent updates)

 

[Guest]

Hi jahoobob,

I tried setting the property of the subform to Dynaset (inconsistent
updates), but this makes matters worse. If I do that, when I enter in
account numbers, the subform no longer pulls up my account info, which is
will do when I set the property to just Dynaset. Also, still no dice with
the one field updating.

The one field that won't update on the underlying table is a field with drop
down choices. The drop down choices are set as a look up in the table, with
the look up looking to another table for the choices. I am wondering if I go
in and choose look up and then type the values I want (as opposed to having
it look in another table) will make a difference? This isn't what I want to
do...but right now I just need that field to update, then I can research/work
further on the issue to make it right.

Thanks,
Dawn