Having 12 text boxes (and 12 fields, I assume, in your table for them) is not the way to go. You should have a separate table which gets an entry for each month you receive a report. So if they first send a report in September, the next time they send a report should be for October. And this can keep going for as many months as you need, no limit to 12 per client. You can use the DateAdd function to add a month from the previous entry.
Tobi -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of wartheit Sent: Wednesday, September 07, 2005 5:41 PM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Autofill text boxes 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. Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/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/
