I have a form with several comboboxes that pull their values from another form. Everything works as expected except for one particular combobox. Its bound column is set to reference a listbox (whose data is populated by a field in a table with a long integer datatype.) The variable used to store the data is declared as a long integer type and when I msgbox the variable immediately prior to setting the combobox's value it returns what I expect. The problem is that the combobox is returning a different value, specifically, the next row in the table instead of the row with the value the msgbox is returning. I've never had this happen before and I'm at my wit's end trying to figure out why this is occurring. Hopefully that makes sense. Any thoughts?
Thanks in advance.
Thanks in advance.