Hey Guys,
To simplify, I'm currently writing a module that (at one point) will allow me to open the "90-Hr Waiting PU Form" to the same record that was on the "90-Hr Sheet Request Form". Here is the full code for the module below:
Code:
DoCmd.OpenQuery "Append from Request to PU (Step 1 to 2)", acViewNormal, acEdit
DoCmd.OpenForm "90-Hr Waiting PU Form", acNormal, "", "[90-Hr Sheet Request Form].StudentIDTextBox" = "[90-Hr Waiting PU Form].StudentIDTextBox", acEdit, acNormal
DoCmd.OpenQuery "Delete Query (from Request)", acViewNormal, acEdit
DoCmd.Close acForm, "90-Hr Sheet Request Form"
The command where I open the form (the one in bold) is the one I'm focusing on. I need to specify the "Where Condition": to open the PU Form to the record that was just appended in the previous line. I'm thinking of making it a filter, so that it opens to where the StudentIDTextBox in form 2 is equal to StudentIDTextBox in form 1. How would you write or change this code to get it to work?
Thank you for your time.