Reshmi mohankumar
Registered User.
- Local time
- Today, 12:01
- Joined
- Dec 5, 2017
- Messages
- 101
UPDATE tbl_Purchase_Details SET tbl_Purchase_Details.IS_Sold = True, tbl_Purchase_Details.bill_num = 123, tbl_Purchase_Details.sales_date = #5/30/2018#
WHERE (((tbl_Purchase_Details.BarcodeID)=[Forms]![frm_Estimation]![frm_estimation_details]![barcode]));
by this query i can update only cursor active field in subform (datasheet view), but i need all barcodes to be update of " [Forms]![frm_Estimation]![frm_estimation_details]![barcode])) " this subform.
please get me out from this....thank you
WHERE (((tbl_Purchase_Details.BarcodeID)=[Forms]![frm_Estimation]![frm_estimation_details]![barcode]));
by this query i can update only cursor active field in subform (datasheet view), but i need all barcodes to be update of " [Forms]![frm_Estimation]![frm_estimation_details]![barcode])) " this subform.
please get me out from this....thank you