Passing data from one form to another

[WAVP375]

A form with a list box shows job number and job description A selection in the list box populates two tex boxes on the for. A second list box shows a list of course numbers and course name. Likewise a selection from the list box populates two text boxes on the form. The form is bound to a table. The form is closed and the new record is saved. Since there will be multiple entries with the same job but different courses I am looking for a way to save the job number and name to populate those text boxes when I open the same form again.



Is there a reasonably simple way to accomplish this.

[pbaldy]

During the same session you could save the values to a global variable, TempVar, or hidden textbox on a form that remains open and use that to populate the values when the form loads. To hold the values after Access is closed, you'd need to save them to a table, use database properties or the registry.

[WAVP375]

Looks like global variable is going to be my solution.

Thanks

[pbaldy]

Happy to help.