Need help,
Here is an issue I need help with ...form 1 inserts data into a database and then form 2 retrieves some of this data from the database when it is open. After form 1 is filled out a button is clicked to open form 2. Now here is the issue: Since form 2 retrieves data from the database which was entered from form1 there obviously need to be some link between the 2 forms. Therefore a transaction number is saved to the database to link the forms. Now I need this number to be available when a user is entering the information: so that when the use clicks to open form 2..form 2 will be able to connect to the database use this number and retrieve the data from form1. I already know how to open a form but how can you send this number to the other form; so lets say its transaction number 10, how am i able to send this variable to that form so it will be able to retrieve the data associated with form 1?
