ACCESS FEED: [MS_AccessPros] Need help on a from and its subform (Collection Voucher)

Rabu, 28 Agustus 2013

[MS_AccessPros] Need help on a from and its subform (Collection Voucher)

Hi all,
i have returned to the group after a long period. Previously i gained lot of information, help and knowledge from members and MVP's like John (special thanks to him.)
I am using Access 2003.
Any suggestions for changing or removing any table already trying to use in the below form would be appreciated with thanks.
I have a form "Collection Voucher"

Tables are:
1- Consignment Number (table)
fields: ConsignmentNo (text,9-input mask: 9999\-A\-99;0;-)
CollectionDate (Date/Time)
form "Add New Consignment Number" is already made to add new consignmentNo

2- Clients (table)
fields: ClientCIN, Number, double
ClientName, text, 30
other fields for this form are not required for above form
Form "AddClient" is already made to add new clients

3- ProductGrade (table) (Grade are "A", "B")
field: Grade, text, 1

4- Products (table) (These are items which we send through our cargo)
Fields: Grade (Lookup Row Source is "ProductGrade"
ProductName, text, 20
Form "Add New Products" is already made to add new Products

5- CollectionVoucher (table)
Fields: CartonNo, Text, 4
ProductName
ProductQty
WeightOfCarton, Number, Double
Rate
Amount

On the main form "Collection Voucher" i need to enter OR select which ever is suitable or required "ConsignmentNo
then "CollectionDate", Grade, ClientCIN, ClientName

On the subform get inputs for: CartonNo (these would be serial No of Carton like 1,2,3....)
ProductName (in its dropdown list only those items should display which "Grade" is selected on the main form.
ProductQty
WeightOfCarton
Rate
Amount

What i require is that for a selected "ConsignmentNo" and selected "ClientCIN" entries made in subform should save and viewed for "ConsignmentNo" and "ClientCIN"

If we select or change "ConsignmentNo" and "ClientCIN" on the main form, subform entries be saved for them seperately

Thanks in advance for supporting as my M.D is pressing hard to use this form for our Consignment/collection of 30th August.
Khalid Tanweer