>No error messages? Trace this code through the debugger. Maybe open the form as a table, and remove all the relative paths to the tables and database in the DE.
Mark,
I finally figured this out. Uuf (sigh of relief)... I used upper(FunName) in my SQL statement. In the table I have mixed cases. I've just replaced MethName with upper(MethName) all in TownsMeth table and now it's working!!!!! Well, it costs me few hours to find it, but I'm glad, it's resolved.
>
>>Hi everybody,
>>
>>I was trying to do the simplest possible thing - and it doesn't work! :(((((
>>
>>I have a form with 2 views and pageframe with two pages. The first page has info from vTownsMethods view. It has field MethName. I have a combobox on the first page with the following properties set in Properties Sheet:
>>
ControlSource=vTownMethods.MethName
>> RowSource="select upper(FunName) as Fun_Name, FunctionID " ;
> +"from AllFunctions where GenCat=vTownMethods.FunType " ;
> +"order by 1 into cursor curFunNames"
>> RowSourceType=3
>> Style=2
If it's not broken, fix it until it is.
My Blog