Beginner needs help, carrying a value between 2 forms

New with Access. I am building a database and I need to cary a value from one form to another for example: If I have a form that you can enter a persons last name and first name, then you have to go to another form to add personal information, how can I carry the last name value to the personal info form?

Thanks for your help.

By far the easiest way to pass information from one form to another is when you load the second form, leave the first form, with the information captured in its text fields, loaded and just reference the text boxes from the first form and put them in the text boxes on the second form


Code in OnLoad event of Second form

FormSecond.txtFirstName = FormFirst.txtFirstName
FormSecond.txtLastName = FormFirst.txtLastName


When you have the information you need and if you don't want to keep the first form loaded, unload it after capturing the info you need.

This method also limits the amount of Global and Public variables in use.

S-

Thank you for all your help.

Drew