Hi,
I have a combobox,

rowsourcetype - field
rowsource - view1.cname,iid
controlsource - view2.foreignID

I have problem that combobox doesn't show the value after I requery view2. When I click the combobox, I see the view1 records, and the corresponding value is highlighted but not shown in combobox. It will only work fine after I click on the combobox. Any ideas?

I used to try combobox.refresh(), combobox.requery() but not help.

Thank you