Did you use a Label instead of a Text Box?

I used the Toggle button as shown in the video.
I have come up with a work around for the time being, putting the VBA code into the "On Got Focus" event for the form.
This works, but I am curious as to why I don't have the "Before Update" and "After Update" events on my Toggle Button Property Sheet?

Hi John,

I suspect the reason that you're unable to access Before Update and After Update is that you're using the toggle button on a report.

Because reports aren't intended for updating data, just reporting on the data you have, the update methods such as "Before Update", "After Update", "On Change", "Dirty", etc., aren't available.

If you are on a form, then I would double check to make sure you didn't grab a command button instead.

Don

Thanks Donald, you have nailed it on the head.
I was trying to use it on a report.
Richard was correct, you guys are the best.
John