>We have many comboboxes whose list data is created with SQL stored procedures. Having the call to the stored procedure in the MOUSEDOWN does not work well with tabbing into the field. Putting the call in the WHEN seems to work well, but is this a proper place for it? If the cursor for the combobox already exists, then the call isn't made to avoid unnecessary calls. But depending on changes to other object values, the stored procedure may need to be run again. Is the REQUERY a place to put a stored procedure call, or can the 'exec sp_whatever' actually be put in the rowsource property, and then issue a combobox.REQUERY?
> Thanks for your help.
Hi Janet,
Just a thought. If it is depending on changes to other object values, you may have some (form) property which is changing along and have an ASSIGN method for this property which will call your stored procedure to update the combo rowsource. Then you just need to REQUERY the combo in When() event.
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison