Hello, I am trying to design a form to record the dates we receive reports from our clients. I have 12 text boxes set up to hold the name of each reporting month. I would like to have all 12 text boxes filled with the names of consecutive months after the name of the first month is entered. For example, if month 1 is April, then months 2 through 12 would autofill in with May, June, July, ... March. If month 1 is October, then months 2 through 12 would autofill November, December,... September. (I hope this is clear. I'm working off some vacation sleepiness).
I've thought of some nested "IIF ... Then" statements, but that would be a lot of coding. Does anyone have any thoughts about how I could do this? A Lookup table of some kind?? Thanks in advance. Paul W. ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
