Expression problem

[dr223]

hallo,

I have two forms, from one form I can navigate to the other form.

What I want to do is that when I populate the Student_ID field on the 1st form, and navigate to the 2nd form it automatically populates the Student_ID field on the 2nd form and saves it to the respective table.

Now, to my understanding it can be done on the 2nd form table, at the Default value where it pops up the Expression builder to write the command...
Can anyone pls help me to write the expression builder command...

the field is called Student_ID
1st form is called stud_details
2nd form is called qual_hist

Many thanks

 

[ajetrumpet]

What I want to do is that when I populate the Student_ID field on the 1st form, and navigate to the 2nd form it automatically populates the Student_ID field on the 2nd form and saves it to the respective table.

Dr,

Default value applies to new record entries. Will you be entering a new record when you switch the focus to the second form? It will work if you are doing that. You can just use a form reference in the default value property line:

= forms!form1!StudentIDtextbox