I'm new to VBA/MSAcces. I have academic project on membership registration DB.

I have Tables for Members and Items

I want when a member's name is searched, if the registration date is a year or more, I should have an Alert "renew registration"

How do I do this on the Registration Form
[IMGNOTHUMB]https://bytes.com/attachments/attachment/10009d155739894 8/reg-form.png[/IMGNOTHUMB]...