Update Query acting up

[compooper]

Hi folks!

Could someone please look over my SQL code for an update query?
UPDATE tbl1 AS A INNER JOIN tbl1 AS B
ON A.ID>B.ID
SET A.[Applicant] = B.[Applicant]


WHERE A.[Applicant] Is Null AND B.[Applicant] Is Not Null;

This code essentially repeats the applicant name for all of the blanks below it, until a new name appears.
So if its:
Bob Smith
blank
blank
blank
Jane Smith
It should update to:
Bob Smith
Bob Smith
Bob Smith
Bob Smith
Jane Smith

The code is working for the majority of the table, but in one RANDOM spot it decides to screw up and starts repeating the same name for more than it really should.
Maybe its in my code. Please take a look.
Thanks!

[June7]

I've never tried this type of query but think can't be random, has to be a reason. Is it always the same records this happens to? (You are testing this on copy of table?) Attach the data as Access or Excel file, remove confidential info.