Hi John.

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?

Try code like this when you requery view2. I assume that the code is in the combo box < s > :

lnValue = This.Value
REQUERY( 'view2'>
This.Value = lnValue