applying one text box value to collection of another text box

[Esmatullaharifi]

I have a form with tabular format containing a text box with the name of session and text box with the name of classSession. This form containing multiple records but when i want to copy the value of session to the classSession text box the copy function is only applied to the first record and not applying to another records. How to fix this issue.

[ranman256]

Use an update query.

[Esmatullaharifi]

i tried to use update query but when i tried to get the value of "update to" from my form i failed. i used something like this
UPDATE Table1 SET Table1.Class=Like "*" & [Forms]![Form1]![session] & "*";
please solve my problem.