The dreaded split

[isladogs]

You're welcome

[DevState]

I'm back, lol. I put the following in my code:

DoCmd.RunSQL ("Termination_strip")

and it bounces back with an Run-time error "3129"

Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'

Any idea why? The query runs if I run it alone.

[isladogs]

As the error says, DoCmd.RunSql is used with SQL statements for action queries such as UPDATE
It can't be used with SELECT statements

If termination_strip is a query then use
DoCmd.OpenQuery "termination_strip"

[Homegrownandy]

("Termination_strip") is not SQL is a query name.

Do this:

DoCmd.OpenQuery "Termination_strip"

[DevState]

Newbie mistake and it works.

Is there a way, out of curiosity, to have my Update query show me what exact records were modified? Like pull the First name and display it in a table?

[Homegrownandy]

you could use an append query with the same criteria. It can be usefull for tracking changes/showing previous values. You would have to make a table specifically for this though.