General information
Category:
Forms & Form designer
>>Has anyone found a workaround for a combobox not being able to display a value that does not exist in it's rowsource? I would like to have it display the value in the controlsource, but I don't want to fill the rowsource until the combobox actually gets the focus. I have a form that has a lot of comboboxes and it would require a lot of individual cursors to be populated before the form comes up. I would rather use one parameterized view for the rowsource of these comboboxes and have the pick lists available only when the combobox gets focus.
>
>It's MS that found the workaround and gave us Combo.DisplayValue property to display value which is not in RowSource.
My combobox is bound to a 'view1.code' field - I want to display the 'view2.desc' field before the rowsource gets filled. If DisplayValue will do this, where do I set combo.DisplayValue? The rowsource is set to view2.code, desc, rowsourcetype = fields. I have tried everything I can think of and still cannot get the combo to display the value.
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