Combo box not displaying data Susanne 12/29/2008 2:10:01 PM Over the years forms have been working great from a 97 Access db. Zoom to today and for some reason it's not, and no matter what I have tried, I can't get the employee names to appear in the combo box. The user is to select a name from the list and the employee id is then stored in the field. The field has 3 lines of information from the name to another number and DOB. I have the data source to look up the info in the employee table and the width set to 0" (employee id) and 2" (employee name). The id will appear if I change these settings, as well as the column heads, so I know the db is reading the column with the names, but there are no names appearing. The tables are linked from a backend. Oh, when looking at the data source in query mode, all the information is there. I have converted the db to Access 2000-2003. So, any ideas?

Re: Combo box not displaying data Rick Brandt <rickbrandt2[ at ]hotmail.com> 12/29/2008 2:14:35 PM On Mon, 29 Dec 2008 06:10:01 -0800, Susanne wrote: [Quoted Text] > Over the years forms have been working great from a 97 Access db. Zoom > to today and for some reason it's not, and no matter what I have tried, > I can't get the employee names to appear in the combo box. > I have converted the db to Access 2000-2003. So, any ideas? Blank ComboBoxes is a bug introduced in Access 2003 with service pack 3. There is a hotfix. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com