tbl_members contains a list of member information, including a Yes/No field if they are current in their training. (field name Current)
Once a member signs in, I have a macro that runs and brings up a form to indicate successful login. (on update of the id field)
However, I also want to check to see if tbl_members shows they are not current ([tbl_members].[current]=false)
If they are, I want to put up a form that indicates such, that also plays a wave file or at a minimum beeps several times.
If they are current, the form is not needed.