First i hope i could express myself correctly because english is not my native language but i'll have to try to get my problem solved.
i'm working with a database to manage the budget, i have a table with five columns with fields like [date_of_movement] [month] [amount] [ref_1] [ref_2].
My problem is that when i create a form based on that table i dont want to type or to select (combo box) the month, i want a command button or a macro that generates 12 new records with the name of the months in it and that i just type the amount and the other fields needed. I don't know if this can be done in an easy way because i'm not an access expert but i'll apreciate any ideas.
Thanks for the help
i'm working with a database to manage the budget, i have a table with five columns with fields like [date_of_movement] [month] [amount] [ref_1] [ref_2].
My problem is that when i create a form based on that table i dont want to type or to select (combo box) the month, i want a command button or a macro that generates 12 new records with the name of the months in it and that i just type the amount and the other fields needed. I don't know if this can be done in an easy way because i'm not an access expert but i'll apreciate any ideas.
Thanks for the help