Subject Re: Combobox From Mervyn Bick <invalid@invalid.invalid> Date Sat, 17 Sep 2022 17:05:11 +0200 Newsgroups dbase.getting-started 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? Mervyn.