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
