Ok this is a weird one stay with me. I have a data entry form that captures all the data for everybody. This is saved to a table called Roster. Each section has their own macro button to open a form with their specific peoples data. There are 2 variables that designate when a person leaves the section, Outbound and ETS date fields that are filled out in the data entry form and saved into the roster table. There is a status in the data entry form that has 2 options, Present and Archive. I want a pop up to show when the section form is opened via the macro to ask if a person is still active because either their ETS or Outbound date field has elapsed. I know that is kinda confusing but I will answer any questions to assist in helping me.