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,

 

[Joseph Meehan]

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,

Maybe.



..




..




..



We need a lot more information about what you really want. Think
about what you have to start with and what you want to end up with. Let's
to go to the data in the tables for example and what you want to edit and or
view.

 

[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,
----------------------------------

 

[Joseph Meehan]

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,

I am still confused about your table structure. How about a list of the
table(s) and each filed in the tables. Change the name to protect the
innocent if needed. eg:


Table1
FirstName
MiddleName
LastName
PhoneNumber
IndividualID


Table2
CompanyName
DivisionName
Location
CompanyID