raziel3
Registered User.
- Local time
- Yesterday, 23:07
- Joined
- Oct 5, 2017
- Messages
- 275
Hello all,
On my main form, I have a combo box for all the vendors and a PurchaseDate text box. Once a vendor is selected I want the subform to list out all the products purchased from that vendor then all I will need to do is enter the quantities.
The subform's record source contains the following fields; VendorID, PurchaseDate, Quantity, and Cost. Additionally, I would like the subform to be able to add new items for example:
Main Form
Vendor Selected: ABC Ltd
Date : 6/14/21
Subfrom
On my main form, I have a combo box for all the vendors and a PurchaseDate text box. Once a vendor is selected I want the subform to list out all the products purchased from that vendor then all I will need to do is enter the quantities.
The subform's record source contains the following fields; VendorID, PurchaseDate, Quantity, and Cost. Additionally, I would like the subform to be able to add new items for example:
Main Form
Vendor Selected: ABC Ltd
Date : 6/14/21
Subfrom
Date | ProductID | Quantity | Cost |
6/14/21 | Apples | 10 | $6.00 |
6/14/21 | Coca Cola | 2 | $10.00 |
6/14/21 | **Enter new data*** |