>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

Hi Tyler,

The right way to have the fresh value in a combo is
mycombo.Requery()
mycombo.Refresh()