A
ACCESS
Guest
I Have Two Form :
1)Main Form : Invoice
Invoice No. : 1079 Inv. Date: 01/02/2000
Customer No. : C690
2)Sub Form : Invoice Details
Inv. # Cust. # Inv. Date Part # Qty. Price
------ ---- --------- ------ ---- ----
1079 C690 01/02/2000 S345 5 120.5
1079 C690 01/02/2000 S458 6 130.5
1079 C690 01/02/2000 S789 6 120.0
1097 C690 01/02/2000 S854 7 130.5
My Question is :
When The User Change The Date Field to 05/02/2000 in Main Form
and Customer No. Field to : C681 in Main Form
How To Update Sub Form To Give My Like This After Update :
Inv. # Cust. # Inv. Date Part # Qty. Price
------ ---- --------- ------ ---- ----
1079 C681 05/02/2000 S345 5 120.5
1079 C681 05/02/2000 S458 6 130.5
1079 C681 05/02/2000 S789 6 120.0
1097 C681 05/02/2000 S854 7 130.5
----------------
All help is appreciated!
1)Main Form : Invoice
Invoice No. : 1079 Inv. Date: 01/02/2000
Customer No. : C690
2)Sub Form : Invoice Details
Inv. # Cust. # Inv. Date Part # Qty. Price
------ ---- --------- ------ ---- ----
1079 C690 01/02/2000 S345 5 120.5
1079 C690 01/02/2000 S458 6 130.5
1079 C690 01/02/2000 S789 6 120.0
1097 C690 01/02/2000 S854 7 130.5
My Question is :
When The User Change The Date Field to 05/02/2000 in Main Form
and Customer No. Field to : C681 in Main Form
How To Update Sub Form To Give My Like This After Update :
Inv. # Cust. # Inv. Date Part # Qty. Price
------ ---- --------- ------ ---- ----
1079 C681 05/02/2000 S345 5 120.5
1079 C681 05/02/2000 S458 6 130.5
1079 C681 05/02/2000 S789 6 120.0
1097 C681 05/02/2000 S854 7 130.5
----------------
All help is appreciated!