I am having problems displaying new values in my combo boxes after a method that I have created on my form.

I have a combo box that has a rowsource of:

select products.product from products into cursor lproducts order by product

the control source is: m.product

In my method I have a select sql statement:

I pass it a value depending on what hotkey a user presses

parameter m.hotter

select hotlist.hotlistid, clients.clientname, grades.grade, products.product;
from hotlist, clients, products, grades;
where hotlist.hotlistid = hotter;
and hotlist.client = clients.clientcode;
and hotlist.prodcode = products.prodcode;
and hotlist.gradecode = grades.gradecode;
into cursor cltest

select cltest
scatter memvar

thisform.refresh

I then want the product combo box to display the new product but it doesn't do it until I tab into the combo box. How do I get it to do it immediately?

TIA,
Tyler