Help, Sub Form (1 Viewer)

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!
 

Users who are viewing this thread

Top Bottom