Date Based Combo Box & Multi Records 1

[ppkgoldengun]

All Seasons Greetings,

Fairly new to Access. I need to populate a combo box with a selection of dates (every Saturday from 1/1/2004). Is there a function or query I can build to do this? The second question is I would then like to populate 7 records in a subform with the dates of the week (sunday thru Saturday). I believe that can be done via referring to the parent form Parent.comboxname. How do I only show 7 records in the subform?

Any help or guidance would be very appreciated.

 

[WildHare]

There may be a couple of ways to do this. You can dynamically populate a combo box by referring to the "rowsource" property, in a loop, something like this:

Dim saturday As Date
For saturday = #1/3/2004# To #12/31/2004# Step 7
Combo0.RowSource = Combo0.RowSource & "," & saturday
Next


This will populate your combo with each of the Saturdays in 2004.


If you think about it, you can probably figure out how to get your seven day records in the subform, from this example....if not, let us know.

Jim


Don't be sexist - Broads hate that!Another free Access forum:

http://www.forumco.com/jmhare

More Access help stuff at

http://www.jmhare.com/wildhare.htm

 

[ppkgoldengun]

Thanks. Code worked great once I figured out that the source type had to be set to value list.

Happy Holidays.