Adding multiple records at a time

[shod90]

Dear Gents,I have an application which some times users would enter the same record number of times everyday , So i need a way to let them insert multiple records on the same form one time only , Something like the attached example .
If the user insert no of days 4 , Then the form sends to the table 4 records.

Thank you.

[ranman256]

use an append query.
it takes the items list and add them to the table.

Queries are the answer for most data actions.

[pbaldy]

Not sure an append query can increment the date. I'd probably use a For/Next loop using the two form controls and the AddNew method of a recordset.

[shod90]

Thanks for your replies ranman256 , Pbaldy .
Actually , Still my experience not too much to understand easily your replies
i also got an idea which in need your help as well maybe easier than the above request .
what about listing the dates in a multiselect listbox .
As an example :
today is 14/Aug/2016
i need to show 1 month in the multiselect listbox ( 15 days before 14/Aug and 15 days after )
Also i need it dynamically , So if we are on 20/Sep/2016 i want the first item in listbox will be 5th of Sep and last item will be 5th of Oct.