Hi,
I have a two combo boxes on a form. When the user chooses an option on the first combo box, I run some SQL code through the after update event to fill in options on the 2nd combo box. This works fine and the user is able to choose the option they wish on the 2nd combo box. If I navigate to a new record and back to the original record, both combo boxes have values in them showing what the user chose.
If I close the form however and then reopen, the value on the 2nd combo box comes up blank, even though there is a value in the underlying field on the table.
Does anyone know why this is happening?
Cheers,
Jason
