ACCESS FEED: [MS_AccessPros] Help on sub form

Minggu, 01 September 2013

[MS_AccessPros] Help on sub form

John-
Thanks for giving the sample code, and sorry for delay in replying it was my weekend.

I have made some changes and now working on it almost its working right.
First of all is that Record source of main form is now "ConsignmentNumber".
(When New Consignment is scheduled user enters in the form bound to tbl.ConsignmentNumber. Fields "ConsignmentNo", "CollectionDate","Grade")
Main form has these 3 above fields, and their Locked property is Yes. Navigation Buttons property is Yes.

I have put subform (so that user may see the previous records entered in the sub form at one place) whose Record Source is: SELECT CollectionVoucher.ConsignmentNo, CollectionVoucher.ClientCIN, CollectionVoucher.ClientName, CollectionVoucher.CartonNo, CollectionVoucher.Number, CollectionVoucher.Grade, CollectionVoucher.ProductName, CollectionVoucher.NumberPN, CollectionVoucher.ProductQty, CollectionVoucher.WeightOfCarton, CollectionVoucher.Rate, CollectionVoucher.Amount FROM CollectionVoucher;

Row Source of ClientCIN is: SELECT Clients.ClientCIN, Clients.ClientName FROM Clients ORDER BY Clients.ClientCIN;

Now what i want is that on the sub form for a new record only records of selected Client should appear which are previously entered for that client, so that user do not see records of other clients.

Secondly data for two fields "CollectionDate" and "Grade" is not updating in the table. I have put them on sub form and also tried to put them on form footer of sub form, Control Source of "CollectionDate" is:=[Forms]![Collection Voucher]![CollectionDate]

Hope you would do the favor as usual. Thanking you in advance.,
regards
Khalid

[Non-text portions of this message have been removed]