Relation Update Only happens on ReQuery

  • Thread starter Thread starter MarkM
  • Start date Start date
M

MarkM

I have a form that is based on a Query that has a relation
between two tables For example, Table 1 has LastName,
Table 2 has LastName, FirstName, Phone#. The relation is
LastName). When I modify LastName in Table 1, the related
info from Table 2 isn't updated unless I requery or exit
the Query and reenter.

The odd thing is that I have another database that has
similar queries & relationships and the related info
updates immediately after I tab out of the "Table 1"
field. It seems to be something related to how the form
is defined, but I can't see it.

Any help would be most appreciated.

Thanks,
Mark
 
The record, of course, is not updated until --

You move off that record to another, or
You explicitly update, e.g., Me.Dirty = False, or
You close the Form, or
You move off the main Form into a Subform.

Your questin reads as if you are expecting something different.

If that's not the case, does the query have the primary key for both tables
included? Is the relationship set with Referential Integrity and Cascading
Update (and is this the Primary Key of one Form so that C.U. will actually
apply)?

Larry Linson
Microsoft Access MVP
 
Back
Top