Screen refresh?

  • Thread starter Thread starter Leslie Isaacs
  • Start date Start date
L

Leslie Isaacs

Hello All

I had a form based on a query of 2 tables, related with referential
integrity.
I now need to include info from a third table, which is related to one of
the first two, so the form's underlying query now has 3 tables.
Initially I found that I could not use the form to update data. From the
help file I find that the way to overcome this is to set the form's
Recordset Type property to Dynaset (Inconsistent Updates):

Question 1: what does this mean, and is it going to cause problems later on?

Having set that property, I have added a combo box to the form that looks up
a value in the new, 3rd table and stores the result in the related field in
the 2nd table. That seems to work OK, except that each time I update the
selection in the new combo box, the other corresponding fields from the 3rd
table do not update - even after doing a form refresh and even after moving
to a different record and back again. The only way to get those other
corresponding fields to update is to close the form and open it again.

Question 2: why is this happening, and what should I do (sorry - that's
questions 2 and 3!)

Hope someone can help.

Many thanks
Leslie Isaacs
 
Inconsistant updates has the potential to cause you problems. The query
wasn't updateable, so the form wasn't updateable. Inconsistent Updates
bypasses the normal integrity checks in Jet and just writes to the table, so
you now have the burden of making sure that the writes go to the correct
location. The query becomes not updateable when there is a theoretical
possibility that the wrong record could be written to. Sometimes you can
work around this by using two queries, put two tables in the first one then
the third table and the first query in the second one.

For the second problem, you may be wanting to Requery, not Refresh.
 
Back
Top