Unanswered: Access --> SQL field returning ID only
I've got an Access project using an SQL database for its data. It seemed fine in the initial form design, and I put a listbox on the form which retrieves dates from one of the columns/fields of a certain table and displays them. The dates look fine, and correct, but I put this is as a test:
And also tried:
Both of these, when activated, return the ID of the entity which the date corresponds to. How can I access the date, as it appears in the listbox?
I could do this the VERY long way round, by taking the ID and using an SQL statement to retrieve the date of the entity matching this ID, but this seems ludicrous.