Interesting thought, Jeff. But... why?

--
Steve Schapel, Microsoft Access MVP


Jeff Conrad wrote:

Looks to me like you are missing the all important line of code to tell
Access to requery the form.

Add this line right below the End Select:

Me.Form.Requery