Reading beginning and ending dates...

[Guest]

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.

 

[Guest]

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