[AccessD] Combo default value strange

Billy Pang tuxedoman888 at gmail.com
Wed Sep 13 14:23:35 CDT 2006


what happens if we rearrange the values in the value list?  does it still
come up as "current week"?

On 9/13/06, JWColby <jwcolby at colbyconsulting.com> wrote:
>
> I use a highly modified version of Julie Schwalm's date picker code.  I
> use
> a combo instead of the radio button group that she used and added a bunch
> of
> new possibilities.  The combo I use to select the date range I want has a
> row source type of "Value list" and a row source of:
>
> 1;Include All Dates;12;Custom Date Range;14;Current Week;2;Current
> Month;3;Current Quarter;4;Current Year;5;Month To Date;6;Quarter To
> Date;7;Year To Date;15;Last Week;8;Last Month;9;Last Quarter;10;Last
> Year;11;Last 12 Months;13;Today;16;Yesterday
>
> In my time tracking / billing database I want to open a time data entry
> form
> to filter to today.  If I put a default value of 1 in the combo (the
> "ordinal value" for "Include all dates"), I get the correct thing,
> "include
> all dates".  If I put 2 in there, I get "CURRENT WEEK", which is wrong, it
> should select "CURRENT MONTH".  IOW, the integer value should select the
> text immediately AFTER the integer value (in the value list string), but
> seems to be selecting the value immediately BEFORE the integer value.
>
> Any thoughts on this?
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Billy Pang
http://dbnotes.blogspot.com/
"Once the game is over, the King and the pawn go back in the same box." -
Italian proverb



More information about the AccessD mailing list