I have setup a global variable. I need to store in this variable the value of Max(RequestID) from tblRequests.
Then, I want to assign the variable to a label control on a form when the form opens (On Load event).
Then, I want to run a query to include this new value into a query field (Request_ID).
What codes do i need to accomplish this?
Thank you all for your assistance.