Rabu, 25 November 2015

[MS_AccessPros] Sub Form to fill with a previously made query and from a table

 

Hi all,
I have a form "Prepare Sale Invoice" after entering data on its few controls, I am entering data on its subform  "Prepare Sale Invoice subform" manually and it is working OK.
But now as the software is now not run by myself, my boss says it is tiresome to enter data manually on the subform it should be filled automatically. I am not mentioning controls of the form at the moment. Just need to know is there any possible way to do that.

I have already a report "Product Wise Summary Selective Consignment And Client" which shows the values for FOUR of my subforms Control that reports Record Source is:

SELECT ProductwiseSummaryCollectionSelectedConsignClients.ConsignmentNo, ProductwiseSummaryCollectionSelectedConsignClients.ClientCIN, Clients.ClientName, ProductwiseSummaryCollectionSelectedConsignClients.ExportDocs, ProductwiseSummaryCollectionSelectedConsignClients.ProductNameEnglish, ProductwiseSummaryCollectionSelectedConsignClients.ProductNameRussian, Count(ProductwiseSummaryCollectionSelectedConsignClients.CartonNo) AS CountOfCartonNo, Sum(ProductwiseSummaryCollectionSelectedConsignClients.ProductQty) AS SumOfProductQty, Sum(ProductwiseSummaryCollectionSelectedConsignClients.WeightOfCarton) AS SumOfWeightOfCarton
FROM ProductwiseSummaryCollectionSelectedConsignClients INNER JOIN Clients ON ProductwiseSummaryCollectionSelectedConsignClients.ClientCIN = Clients.ClientCIN
GROUP BY ProductwiseSummaryCollectionSelectedConsignClients.ConsignmentNo, ProductwiseSummaryCollectionSelectedConsignClients.ClientCIN, Clients.ClientName, ProductwiseSummaryCollectionSelectedConsignClients.ExportDocs, ProductwiseSummaryCollectionSelectedConsignClients.ProductNameEnglish, ProductwiseSummaryCollectionSelectedConsignClients.ProductNameRussian;

One more controls value i need to get it from table "Invoice Values PakCaspian Ammended"

These should be filled for specific "ConsignmentNo" assigned on Main Form and "cmbClientCIN" on sub form.

I read about append queries, but don't know the correct method to apply it.

Can i get help in this regard.

Regards,
Khalid 

__._,_.___

Posted by: Khalid Tanweer <khalidtanweerburrah@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar