Update appears in underlying table but not in query (Join)

  • Thread starter Thread starter Elias Ali
  • Start date Start date
E

Elias Ali

even though criteria selects all records..the form is
linked to the query (join) so updates are made to the
table but they don't appear on the query
 
even though criteria selects all records..the form is
linked to the query (join) so updates are made to the
table but they don't appear on the query
Click to expand...

This will often happen when the update affects one of the fields used
to join the two tables, in such a way that the newly created record is
not returned by the query; or if the query has criteria, the new
record might not match the criterion.

Please post the SQL of the query and an example of a record which
should be displayed but isn't.
 
Back
Top