Make rows in a subform based on a date entered in the Main Form

[vibinmvenugopal]

I have a text box field to enter start date.

Once the start date is calculated, the access should calculate the next 10 working days and auto populate those days in a sub form.

Is this possible?

[CJ_London]

yes it's possible.

it will need to populate the underlying table to the subform. Assuming

1. working days means Mon-Fri and you are ignoring holidays
2. 'next 10' means start date plus another 9 days (10 days in total)

then some code in the unbound textbox afterupdate (or perhaps better on a button click event) would be something like

dim I as integer
dim j as integer
I=0
j=0
while I<10
    if weekday(nameoftextboxhere+j,vbmonday)<6 then 
        currentdb.execute("INSERT INTO myTable (wDate) Values(#" & format(nameoftextboxhere+i,"mm/dd/yyyy") & "#")")
        I=I+1
    end if
    j=+1
wend
mysubformcontrolnamehere.requery
mysubformnamehere.form.filter="[WDate]>=#" & format(nameoftextboxhere,"mm/dd/yyyy") & "#"
mysubformcontrolnamehere.filteron=true

tip, set format of your textbox to short date to enable the calendar selector