Er i didnt understand any of that im pretty new to Microsoft access and vb.

i thought something like strlink (xxx)=!me!(xxx) might do something like 
this.. i mean a similar bit code like that.



> This is very much a style thing as there are many ways to do what you 
are 
r> equesting. 

> I will offer three solutions:
1> ) If you are keeping state only in the form (i.e. you dispose of the 
r> ecordset, and you do not load the data into state objects.
 >    Create public properties on Form2 that are StudentName & 
StudentNumber 
(> typed appropriately). Before you do the Form2.Show, set the values of 
t> hese properties to the StudentName & StudentNumber. Have the properties 
d> o whatever is appropriate for your needs.

> 2) If you are keeping state in a recordset. Add a property to your form 
f> or the Recordset. Now you can read the properties from the recordset, 
and 
p> opulate the form. You can also then have Form2 change the values in the 
r> ecordset if it it appropriate to do so. If you pass the recordset by 
ref, 
F> orm1 will see the changes.

> 3) If you are keeping state in some form of state objects (that you 
c> reated or are in a library). Create one or more properties (In form2) 
(> depending on your object structure) and pass the objects that hold your 
s> tate to Form2.

> John.

> 

> 
>>  Hi,

> > I have two tables (Table1, Table2) and two forms (form1 and form2) 
Form1 
a> > nt Table1 are linked. Form2 and Table2 are linked.  

> > In Table1 there are student names and student numbers.  The form for 
t> his 
h> > as only two fields. Name and Student Number.  

> > AT the moment I have got this query and when I enter a student number 
i> nto 
t> > he field it automatically fills in the name field when i tab out of 
the 
S> > tudent number field.

> > I then have a button on this form  and when I click it, it opens form2 
w> > here it also has Student Name and Student Number but these are 
blank.  
C> > an they not be filled in from the first Form where they already exist 
a> t 
t> > his point.

> > Can anyone tell me how to do this.