Originally Posted by
John_G
I suspect there is an issue with the combo box. I expect it is showing you the text of the genre names, which are associated with a Genre_ID. So, several questions:
1 - does the combo box include the Genre_ID as one of its fields (usually the first field, and hidden)?
2 - what is the bound column of the combo box?
3 - is the combo box bound to a field in the underlying table for the form? If so, what is that field - might it be Genre_ID?
My guess is that the Genre_ID in the form's underlying table is getting an erroneous value (or none at all)