Hi David,
>I have a dropdown combobox which has a cursor (editable) as its rowsourse with the type set as alias. It has a variable as controlsource.
>
>When I requery the cursor, I want the combobox to display the current record of the cursor. I have used all sorts of combinations of the code below, but it just won't display as I want it to. Can someone tell me what I am doing wrong?
>
>Do MyProgram && SELECT THE CORRECT RECORDS FOR MYCURSOR
>thisform.combo.requery
>sele mycursor
>if reccount("mycursor")>0
> locate for mynumfield=storedNumber
> if .not. found()
> go top
> endif
> m.control_source_variable=mycursor.myfield
> thisform.combo.value=mycursor.myfield
>endif
>thisform.combo.refresh
When you bind a numeric to a ComboBox you need to set BoundTo = .T. This should solve it for you.
HTH,
Bill Armbrecht
VFP MCP