I am new to access development and I need to work on a issue.
We have a form with product details and a subform in the form of a grid where we need to enter some cash values. The sub-form has 3 columns in the grid.
I want that when a new product record is shown the subform is shown with 30 rows with the first column having values 1-30 and the corresponding columns blank which can be edited later.
Attached is a screenshot of what my form looks like.
Please help me with some sample code.
![]()