I develop things at home and then deliver a dummy database to my user who deletes various objects in his DB and imports the updated objects from my dummy DB.
In his DB, he has a form with an unbound list box which lists employee names. The SQL is held in the RowSource line and it is SELECT EmployeeID, Trim([LastName] & ", " & [FirstName]) FROM....
In his version of the form, ID is not displayed; it is column one and the bound column, but has 0cm width.
In my updated version, he wants the ID displayed in case two or more employees have the same name. The display is to be Name then ID.
I've reversed the SQL so it now says SELECT Trim([LastName] & ", " & [FirstName], EmployeeID FROM ..... and changed the list box to a) display the ID by giving the column a width and b) changing the bound column to 2.
All works fine in my DB.
However, when I try a sample installation and import the new form, the data is displayed ID then Name, even though the RowSource is as above! Totally baffled, I clicked into the RowSource line and then clicked on the ... symbol at the end. The query design view showed that the fields were in the order I required. I closed the design view and all the other dialogue boxes and then was asked "Do you want to Save Changes?" What Changes? I haven't made any. Answering Yes, the next time the form was opened, the data was the right way round! I've repeated this several times, so it wasn't the fact that I'd had a lot of funny juice.
![HairOut :hairout:](./images/smilies/hairout.gif)
Any ideas, please?
Silverback