rgivascu 0 Newbie Poster

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.