Passing Data From One Form to Another Form

[ETCallHome]

Hi,

I am the new kid on the block and calling home for help. I created a Master Table (Eg. ID/First Name/Last Name) and a Another Table (Eg. ID/First Name/Last Name) these fields are common to both tables. I created a form1 and enter the details for the Master Table, then created a command button to open Form2 that uses the data from the other table. I want to pass the common data from Form1 and populate the data on form2 without having to enter the information again...



Please help....

[pbaldy]

After opening the second form:

Forms!SecondFormName.IDField = Me.IDField

You should know that generally you would only store the ID value in the second table, not the names.

[ETCallHome]

As mentioned... I am new at this... where on the second form do I enter the command you gave me... I really appreciate your speedy response

[timmy]

you can do this pretty easily i think. just right click the text box (in design view on the form), select Properties, click the Data tab, select "..." button next to control source and navigate to the field you want it to pull data from.

[ETCallHome]

Hi Timmy, thanks for your reply... I tried what you said and it does not bring the data across from Form1 to Form2. I even tried to enter the code in a Private Sub Form_Load and it still does not display...

Any other help would be much appreciated...

Thanks
Earl

[pbaldy]

You can push it from the code in the first form that opens the second form or pull it from the second form. The code I posted would be pushing from the first form. The syntax is:

DestinationPath = SourcePath

[thhui]

The logic seems to be:
On 1st form, create a button and code it
1) to open the 2nd form
2) 2nd form field value=1st form field value