Combo Box / Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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

EdS said:
Hello.. I would like to use a Combo box drop down selection to be the
Click to expand...
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?
 
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
Click to expand...
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?
 
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".
 
Back
Top