Hi All,
I'm having a problem trying to get the correct return value from a combobox that uses a sql select as it's recordsource.
Here's the code in the rowsource:
select DISTINCT yr_bred from master where yr_bred > 1995 ORDER BY YR_BRED DESC into cursor yrbred
The combobox populates with the data I want to see, but when I use the combobox.value in the where clause of a subsequent SQL select, the value appears to be the order in which it appears in the combobox, not the actual year.
Here's what I mean:
The "select distinct..." creates a cursor with 5 records as a result;
2000
1999
1998
1997
1996
These years show up in the combobox dropdown.
If I select the first year, 2000, the value being used in the next select is 1, the order 2000 appears in the dropdown. If I select 1997 the value returned is 4.
I'm storing the comboxbox value to a variable to be used in the subsequent select statement (ie. myear = combobox.value) and I've set the value property in the properites box to 0, for numeric.
Any ideas as to what I need to do to correct this behavior.
Thanks,
Jim Harvey
jharvey@netrax.net