>In a order entry form.
>The supplier code is selected from a combo box named cboSupplier.
>And the product code is selected from a combo box name cboProduct.
>The product code of the cboProduct should be filtered by supplier code.
>How can i execute the requery.
In the InteractiveChange method of cboSupplier....
THISFORM.cboProduct.Requery
THISFORM.cboProduct.Refresh()
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05