SQL fires when the combo is created. If you want to execute it again, call ComboBox.Requery() method after customer record is changed.
>Here's one that's confounded me so far....I have a grid with one field - a combobox control. the rowsourcetype is set to 3-SQL statement and the rowsource is:
>
>
>select haulername, haulerid from hauler where haulerid not in (select haulerid from customerhauler where customerhauler.customerid = l_cust) into cursor l_haullist
>
>
>l_cust is a variable set in the calling program and is changed whenever the customer record is changed (in the form.refresh method).
>
>The combobox is doing a select of the grid being edited. The end result is supposed to be that if 3 of the 5 choices are already showing within the grid, then only show the other two as possible choices within the combobox.
>
>The sql code works at the commandline, but gives all records for l_cust during program execution.
>
>Any suggestions?
>
>Thanks in advance
- Jayesh