Update query not updating records even though message stating about to update records

[sfspca1]

I am trying to update two fields in a master table called Foster Care from another table called FosterCurrent New. The two fields to be updated are Availability (text) and Foster (True/False). I have an Inner Join on the field "Last and First Name from Foster Care and "Teextbox112(Last and First Name) from FosterCurrentNew. When I run the query, I receive the message that 154 records are to be updated, I select Yes. The records are not updated. The checked the fields from both tables, they are the same.

UPDATE [Foster Care] INNER JOIN [FosterCurrent New] ON [Foster Care].[Last and First Name] = [FosterCurrent New].Textbox112 SET [Foster Care].Foster = [FosterCurrent New].[Foster], [Foster Care].Availability = [FosterCurrent New].[Availability];




Any help you could provide would be greatly appreciated.

[ItsMe]

... The records are not updated. The checked the fields from both tables, they are the same...

Yes, the code you provided will update Foster Care with the values from the other table where Textbox112 and
Last and First Name are equal.

[sfspca1]

Thanks for the help. Checked again and surprise it is working correctly. Problem is solved.

[ItsMe]

Cool. Nothing was jumping out as for the reason it would not perform quickly. I would guess the slowest part of the whole thing would be the combo retrieving data. However, this happens before the AfterUpdate event.