display 2 weeks date in combo box

[elif]

urgent!!!!

i want to knwo how can i display 2 weeks date in combo box ?

e.g today is 6/22, then in combo box, there should have date from 18/6 - 2/7 for user to select.

how can i do it? one idea is set the row source, but how can i combine different date together?

hope all those can help me!!!! :)

waiting for reply

[CaptainD]

First, what database / program are you using. MS Access or ??

Second, what does "18/6 - 2/7" have to do with "6/22"?
6/22 is June 22nd, 2/7 might be Feb 7th but no where close to June 22nd and 18/6, who knows

e.g today is 6/22, then in combo box, there should have date from 18/6 - 2/7 for user to select.

In Access, comboboxes have "Additem" to insert values

cboMyCombo.Additem "First Item"

In your case, you can use "Dateadd" to add two weeks to a date to build a range.

[elif]

i am sorry that i didnt' explain my problem clearly but thanks for
your suggestion

i have already fix the problem.