General information
Category:
Forms & Form designer
Title:
Requery combo boxes
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only