General information
Title:
Combobox - using a SQL stored procedure as row source
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.
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