Copy values

[Eric]

Is there any easisest way by which i can copy some values from one
subform to another based on outlets in Form B.

SubForm A
Outlet Equipment
1 ajajaja
2 kakakak
3 lalakha
4 trtrtrt

SubForm B
Outlet Equipment
1
4

Thanks,

 

[Eric]

There are two different tables one table contains information about
outlets and equipments. program ask the ticket number and on the basis
of that number it display data from one table. 2nd form search data
from another table where information is
save on some of the outlets without their equipments. One subform shows
data in that form:

1st subform
Outlet Equipment
1 kdkdkd
2 trtrtr
3 bcvcvc
4 jrfuuf

2nd subform
Outlet Equipment
1
3
I create a text field in the 2nd subform by the name of text8 and try
to use ths way but it shows error:

Private Sub Text8_BeforeUpdate(Cancel As Integer)
SELECT tbl_EquipmentChronology.Equipment1 as text8 FROM
tbl_EquipmentChronology WHERE tbl_EquipmentChronology.Outlet =

Forms!tbl_PPVResearch_New!tbl_PPVResearch_New!Outlet
End Sub

Compiler Error:
Expected: Case

I need to display the name of equipments from subform 1 of those outlet
which are in subform 2

Thanks,
----------------------------------