Hello,
I hope this is not a repeat of a question. I have form2 that opens when a user clicks a button on form1. Now the user is asked to select a date using picker and that date is passed to a hidden textbox on Form1. Now the code in the button continues to run and utilize this date however it seems it is using the last value in the textbox before the new one populates even though the code is well after the form2 opens. I user this value to update a recordset field. Any ideas how I can achieve this?
I hope this is not a repeat of a question. I have form2 that opens when a user clicks a button on form1. Now the user is asked to select a date using picker and that date is passed to a hidden textbox on Form1. Now the code in the button continues to run and utilize this date however it seems it is using the last value in the textbox before the new one populates even though the code is well after the form2 opens. I user this value to update a recordset field. Any ideas how I can achieve this?