Hi there,
I am creating a mini sample project for tracking inventory for my office. i almost finish everything except this last part.
what i want to do is:
I have a main form called formdistribution which also has a subform called item for issue. The subform bounds to a table which holds 15 records of inventory. In the main form i also have a combo box which contents no.: 1; 2; 3; 4; 5. 1= Province A; 2= Province B; 3= Province C; 4= Province D; 5= Province E.
Now i select no.: 1 from pulldown combo box. i want this no.: 1 to paste to Provcode column in the subform for all 15 records of inventory.
Can someone help please?
How?
I am creating a mini sample project for tracking inventory for my office. i almost finish everything except this last part.
what i want to do is:
I have a main form called formdistribution which also has a subform called item for issue. The subform bounds to a table which holds 15 records of inventory. In the main form i also have a combo box which contents no.: 1; 2; 3; 4; 5. 1= Province A; 2= Province B; 3= Province C; 4= Province D; 5= Province E.
Now i select no.: 1 from pulldown combo box. i want this no.: 1 to paste to Provcode column in the subform for all 15 records of inventory.
Can someone help please?
How?
