Hello.
I'm having a baffling issue and I would hope that someone where has at least seen it before and can offer a work-around, if not a fix.
I have a combo box. I have lots of them, but let's go to one specific form.
On this form, I am adding a person to a task. My combo box has a straightforward row source:
Code:
SELECT Personnel.ID, Format([ID]) AS [ID-Text], Personnel.FullName, Personnel.LastName, Personnel.FirstName FROM Personnel ORDER BY Personnel.LastName, Personnel.FirstName;
I am CASTing the ID (an auto-number PK) to text based upon the suggestion from the Internet, which is odd, but seems to work--sometimes.
UPDATE: This is fixed. I think. I'm leaving this here for others to find. User "dan some" posted about the importance of DISTINCT in your row source query.
I have no repetition, but putting DISTINCT in there--to guarantee no repetition...of auto-numbered fields--seems to have fixed this.
It surely cannot be just me having this issue here, can it?!