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

[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

 

[Van T. Dinh]

Try explaining the problem you have in more details, please.

 

[John Vinson]

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

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.