To all VBA Gurus and Access Form Experts,
There is a table that user need to fill up using a a front end form.
Example: When user selected a value for icode,, cntryCode and pipeline(however many), on hitting the button “add selection” – the macro adds new rows to the table. At that point – users can just type in the Values for cat1Cost,cat2Cost and cat3Cost in a datasheet view within the same form.
For example >> (1) when I select >>
cntryCode = “CN”
icode = “11”
Pipeline >> “D201” , “D301”
See attached “before please” for how the form might look at that point before the button is pressed
(2) then press the button “Add Selections”
(3) Two rows get added to the [Item_Country_DisPipe_LINE
] table and also show up in the subForm - frmItem_Country_DisPipe_LI
See attached “afterplease” for how the form will look after pressing the button and then typing in the price for the cat1Cost,cat2Cost,cat3Cost