Need Help Filling in Text Boxes

[bdog2g]

I have a data base that has ProjectStart Date adn Project Finish Date, well on a subform, I have a row of 24 unbound text boxes named Date1, Date2, Date3, etc. Is there a way in VBA to fill in these text boxes with dates in increments of month-year between the start date and the finish date (ie. ProjectStart=02/02/02 ProjectEnd 02/02/04 and the text boxes are filled with the months in between these dates) More specifically is there a loop structure that can refer to these controls and fill in the appropriate dates.

Any help would be much appreciated

 

[braindead2]

perhaps a bit over simplified but just a simple loop where you refer to the control and using the dateadd function should do it
for x = 1 to 24
me!("date" & x) = dateadd("m",x,projectstart)
nextx