How to access a

[NickBlake]

Hi

What I need to know is if there is a way I can access the information gathered by a data control in 1 form on a different form.

The code I am using below lets me access the database using data2 from form1 so that I can find a particular record and display all the information in the fields on form1. What I want to do though is to execute this code using a button on form2 but display the information on form1. Is there any way I can declare the data control data2 as global.

FindRefNo = InputBox("Please enter the reference number you wish to find", "Find Reference Number&quot
Set mytable = Data2.Recordset

mytable.Index = "PrimaryKey"
mytable.Seek "=", FindRefNo

 

[cjac]

You could put the code in a module and explicitly name the forms with the contols on, ie. by using:
form1.mycontrol1
form2.mycontrol2
This way you could pass data local to the module between the 2 forms.