Hi
I have a table with the heading and the text box name as mention below
I have a save button in the Form
I need VB coding to save the date which is update in the text box to the Table and once update need to get a message box saying it is saved and all the value in the text box should be empty to update new data
Please help
Table Name is (SALESTABLE)
Contract Date (Table heading) - (T1 Test box Name)
First shipment(Table heading) - (T2 Test box Name)
Last Shipment(Table heading) - (T3 Test box Name)
Customer(Table heading) - (T4 Test box Name)
Country(Table heading) - (T5 Test box Name)
Market(Table heading) - (T6 Test box Name)
BRM Month(Table heading) - (T7 Test box Name)
Contract Number(Table heading) - (T8 Test box Name)
Code(Table heading) - (T9 Test box Name)
BRM Category(Table heading) - (T10 List box Name)
Micro(Table heading) - (T11 Test box Name)
Original Contract Price(Table heading) - (T12 Test box Name)
INCO TERMS(Table heading) - (T13 Test box Name)
Contract Price FOB Basis(Table heading) - (T14 Test box Name)
Entire Contract Qty(lbs)(Table heading) - (T15 Test box Name)
Contract This Year(Table heading) - (T16 Test box Name)
Contract Next Year(Table heading) - (T17 Test box Name)
ITEM#(Table heading) - (T18 Test box Name)
I have a table with the heading and the text box name as mention below
I have a save button in the Form
I need VB coding to save the date which is update in the text box to the Table and once update need to get a message box saying it is saved and all the value in the text box should be empty to update new data
Please help
Table Name is (SALESTABLE)
Contract Date (Table heading) - (T1 Test box Name)
First shipment(Table heading) - (T2 Test box Name)
Last Shipment(Table heading) - (T3 Test box Name)
Customer(Table heading) - (T4 Test box Name)
Country(Table heading) - (T5 Test box Name)
Market(Table heading) - (T6 Test box Name)
BRM Month(Table heading) - (T7 Test box Name)
Contract Number(Table heading) - (T8 Test box Name)
Code(Table heading) - (T9 Test box Name)
BRM Category(Table heading) - (T10 List box Name)
Micro(Table heading) - (T11 Test box Name)
Original Contract Price(Table heading) - (T12 Test box Name)
INCO TERMS(Table heading) - (T13 Test box Name)
Contract Price FOB Basis(Table heading) - (T14 Test box Name)
Entire Contract Qty(lbs)(Table heading) - (T15 Test box Name)
Contract This Year(Table heading) - (T16 Test box Name)
Contract Next Year(Table heading) - (T17 Test box Name)
ITEM#(Table heading) - (T18 Test box Name)