For the top section of the code if you would just do Msgbox NextBD at the end of it

For the bottom section,
Msgbox NextBD([DateField])

Hi Adam,

I made several attempts with different iterations, but I can't get the code to work. I think I am going down wrong road with the MsgBox. Should I build calculation in the Table instead? Or, build a query?

That stuff goes in a query, not the VBA editor. 😁

Copy and paste the bottom section into its own area, outside of the button. Then inside the button do the msgbox nextbd([datefield]) all by itself

There's a VBA function under all that.

Thanks guys, I just realized that I am applying this to the wrong result. I am actually trying to figure out how to determine when a client turns 21. I decided for the time being for users to manually enter this information into the client form.  I am finding references for how to do this in Excel but not Access. Not sure if I can create this function in Access. Any ideas?

If you want to know when someone turns 21, just do
DateAdd("y",21,DOB)

If you want to know how far away that is, use DateDiff to compare that date to the current date

Thanks Adam, that did the trick. I suppose I need to do a deep dive into VBA soon.

That's what the developer lessons are for. Dive away! 😁

Developer is next on my list.