Passing a field from one table to another in multiple forms

[Guest]

Hi

I have 3 tables that have a key field LoanID. There is a one one relationship between the three tables
I have 3 forms and each form has a LoanID field that I would like to pull from the 1st form
Each form is attached to it's corresponding table; Form1 to table1, form2 to table2... etc
Senerio
When a user opens the database and completes a new application
The first form opens and the user fills in the LoanID and Bank manually and then they click on a button that takes them to the next form in sequence and they fill the LoanID and Bank manually on form 2 and so on in the next form
Desired result
I would like to prefill the LoanID and Bank name from form 1 in to the LoanID field on form 2 and Form3

Currently (after each form has been completed by the user) the buttons that open up the next form completes a lookup for record that matches the previous form and loads it

I do have a gloabal variable set "Public LoanID As String"
The LoanID field in the 3 tables has a datatype of "Text
It is index (No Duplicates) the Key field
What is the easiest way to accomplish this

I hope the above is clear
Thanks
Patrick

 

[Albert D. Kallal]

Since the information is available by the id, then you NEVER need to
actually copy the data..but only display it.


Consider using a sub-form. I explain how at:

http://www.attcanada.net/~kallal.msn/Articles/fog0000000005.html

You can also use the dlookup function also. I would use dlookup if you just
need the one field from the related table to display.