Combo Box / Date

[EdS]

Hello.. I would like to use a Combo box drop down selection to be the current date. I do not want to default the current date, and the user must also be free to enter a different date.. Any help?

 

[DubboPete]

Hello EdS

More people than me are going to ask why you want "a combo box drop down
selection to be the current date", and then you say "I do not want to
default to the current date"... that statement contradicts itself.

more info required.... and a question:

why use a combo box to select the date, when you can use a Calendar (ActiveX
control) which can pop up and do the same job?

Do you want users to be able to select any date? (The calendar control will
do this for you...)

DubboPete

Hello.. I would like to use a Combo box drop down selection to be the

current date. I do not want to default the current date, and the user must
also be free to enter a different date.. Any help?

 

[Gerald Stanley]

If you want only the current date in the dropdown, try
changing the RowSource SQL to something along the lines of
SELECT DISTINCT Date() FROM MyTable

If you want to include the currentdate within a list of
other selected dates, try changing the RowSource SQL to
something like
SELECT DISTINCT Date() FROM MyTable
UNION
SELECT dateColumn FROM MyTable

In either case, you will need to change MyTable and date
column to suit your app. If using the first option, I
would recommend choosing the table with the least number fo
rows.

Hope This Helps
Gerald Stanley MCSD

-----Original Message-----
Hello.. I would like to use a Combo box drop down

selection to be the current date. I do not want to default
the current date, and the user must also be free to enter a
different date.. Any help?

 

[EdS]

Sorry..I should have said "I do not want the current date filled in automatically by default", just allow it to be the "dropdown choice".