hey stumped beginner,
scenerio:
2 comboboxes one with beginning date and the other with ending date.
after you select the second date youd want 6 textboxes to be created
and in
them you want the dates formated? well you could do something liek
this where after the second combobox "AfterUpdate" sub use the following
format:
for i=1 to Format(combobox2name - combobox1name, "yyyy")
[add each date between that range in the 3rd combobox]
next i
This is untested. you might have to tweak it a bit. but this is the just of
what you need to do. Hope this helps alittle
> I am trying to create a form that will take Start Date and End Date from the
> main form and give me a text box for each year between the two dates.
>
> Example:
> Start Date is 05/31/2000; End Date is 1/12/2006... when I go to the second
> form, I want text boxes for 2000-2006 to appear.