Re: [api-dev] How to force a Combobox to refetch value list?

2005-09-07 Thread Paolo Mantovani
Alle 20:08, martedì 6 settembre 2005, Andrew Jensen ha scritto: [...] What I have is two comboboxes, each allowing the user to select data for a different column on a common row of a table. In ComboBox2 the available options are changed depending on what was choosen in CombobBox1. Ok the

Re: [api-dev] How to force a Combobox to refetch value list?

2005-09-06 Thread Paolo Mantovani
Hi Andrew, Alle 16:51, martedì 6 settembre 2005, Andrew Jensen ha scritto: Hi I have the following question. I have a dataform with a Combobox control and want to change the SQL selection statement at run time, how do I get the control to refetch the data? [...] ComboBox2.ListSource =

Re: [api-dev] How to force a Combobox to refetch value list?

2005-09-06 Thread Andrew Jensen
Paolo, Yes the SQL is just a simple Well the SELECT statement is built with this ugly thing sGender = oEvent.Source.Text sSQl = "select " "name" " from " _ "names" " where " "gender" " = " sSQL = sSQL "'" sGender "'" the sSQL