Mervyn Bick <firstname.lastname@example.org>
||Sat, 17 Sep 2022 17:05:11 +0200
On 2022/09/17 16:46, bob McKinney wrote:
> Hi All: I 'm having a problem with comboboxes being used for lookups. In my datamodule all of the lookup tables
> have the SQL set to [ Select * from "table name"] (Customer", Country, whatever). On a form the combox is datalinked to [ State ID ] - (Country ID, typeofbus ID, terms ID, or whatever).
> 1st Problem: On this test form I can't get the combobox to load. The dropdown is blank.
> 2nd Problem: On another form, I don't know what I did to load the comboxes but I did. I selected a state,
> ( Country,Terms, Whatever) ,It not only loads the rowset's state field that you are working with, it also changes
> every rowset State field in the whole table. (like the old code While not EOF() ) Not too helpful.
If you are only using each combobox to look up a value then assign the
field to the dataSource property NOT to the dataLink property.
The most likely cause of an empty dropdown list is an empty table. :-(
Has the query's active property been set true in the data module?