By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,871 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

Combo box with calculated RowSource

P: n/a
Rather than have the user enter the first day of a pay cycle and the
last day, I would like to have a combo box pre-populated with dates
representing the end of the cycle (Fridays). I would also like to set
the default value to the latest payday (ie the most recent Friday).
Does anyone have any ideas how I might populate the RowSource? I
could build a table of such dates but that seems a bit agricultural.
Does anyone have a more elegant solution?
Regards David

Jul 19 '06 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Sorry everyone .... I've sorted it.

I just loop backward through 52 Fridays, adding the dates to a string
and then set the combos RowSource to that string.

Jul 19 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.