combobox with dates

  • Thread starter Thread starter ReidarT
  • Start date Start date
R

ReidarT

is it possible to make a combobox referring to a date and then enter dates
in it to lookup records in a form.The date has to be on format ddmmyy.
best regards
reidarT
 
Dates!!!! Bad news for Aussies and anybody else who does
not use mmddyy. It's about time MS put in compliance with
the regional settings

Just populate the combo with the dates required in string
format remembering to separate them with semicolons.
However,when putting the date back into the criteria
remember
1. To enclose it between #s eg "[Date] = #" &cboDate &"#"
2. To pass the date back to Access in a suitable format eg
"[Date] = #" &format(cboDate,"Medium Date") &"#"

If you pass the date back in a Medium Date format you get
around the problem of regional variations. There is a
multitude of ways around but I tend to prefer this one.
You may get a few responses about which one is best
HTH
Terry
 
Back
Top