inconsistent updates and the consequences

[lynn atkinson]

I have a form based on a query which when the employeeID is entered, the
forename and surname are displayed. However, I have had to make some changes
which included adding a new table which, in turn, made the query not
updateable. I have solved this by changing the properties to dynaset -
inconsistant updates, but in doing so I now cannot get the fields to display
the forename and surname with the input of the employeeID. If I close the
query (or form based on this query) then reopen it, the information is
displayed.
Does this make logical sense? Is there a way I can get round this problem as
I want to display the info on the form.

 

[Linda Burnside]

Try creating an event on Update with the following line between the subs:

Me.Requery

Linda