Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Category:
Forms & Form designer
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only