Marcia,

At first I had it setup as a SQL Cursor then changed it based on an Array. I couldn't get it to work and after seeing what you and Mike suggested I went back to a Cursor. I believe the problem was that I didn't have it Bound. Once I did that, it seemed to work fine.

One follow-up question though... The DisplayValue changes automatically to whatever the Name value is. Is this normal behaviour? No matter what I change it to, or if I set it to the default, it changes back once I save the form.

Renoir

>Hi Renoir.
>
>>> Simple, I'm sure, but how do I get the current value of a field in a view (set as ControlSource) to show as the initial value in a Combobox? I am also trying to use SQL as the Rowsource (pulling from the same view that contains the ControlSource) so the user can get a list of all current values for that field to choose from. Am I approaching this incorrectly? Thanks! <<
>
>Typically, you use a combo box to pull information from one table (a lookup table ) into its RowSource so that users can pick a value to use as data in another table (the one to which the combo is bound...the one that contains its ControlSource )
>
>How is your combo set up? RowSource, RowSOurceType, ControlSource, BoundColumn? And if your ControlSource is numeric, you must set BoundTo = .T.
>
>If your combo has a ControlSource specified, refreshing the combo should display the correct value. Is this not happening for you?
>
>Marcia