Hello,
Im looking to create a automated system that we process Test requests though. I use a form called "Main TR Dev" to view the test request and change them with the needed data after they are submitted. Once they are filled out I will changed the variable named "Status" to approved/In Test/ect. This is where things get tricky (For me at least), I want to send a automated email to the requester that their Test request has changed status. I have tried querying the current record with no success as im using a data sheet in the footer of the form to select what Test request I want to view. I know I missing a ton of info but do not really know what you guys need to help me out.