I have many combo boxes in a database I am building. This latest one has been behaving like non other. This is in a linked detail subform with multiple lines. Everything works fine. It inserts the value into the intended field (Long) but the search value (2nd column) can only be seen when the cursor is in the field otherwise is shows as nothing is in the control. The first record in the detail table does show the contents but none of the others are seen.
The LotNumber column should all have entries in them. The combo box does fill in the value into the table though.
See the attached image
Any ideas?
Thanks