Hi John,

Did you try Rowsourcetype - Alias instead?

>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