Does anyone know why my combo box is not doing as I expected. I have a form which was created a few weeks ago, and have now decided to add a combo box to this form, the combo box uses the row Source property to read the data from a table the field name in the table is called 'user_code'
When viewing the query in view mode I can see the data I expected however when I save the form and open it in normal mode the drop down display the right amount of rows but I cannot see any text.
The combo is not bound to anything, I was going to use the after update event to filter the other data on the form.
UPDATE: I have noticed if I add more than one column to the row source i.e. User_code and Name and set the bound coloumn to 1 (user_code) and column count to two if I click the combo the dropdown will display blank under user_code but I can see the names in the name column when I select one nothing gets displayed in the combo box the value is null