This works great until I create a new record and re-load any previous record, which then loads the form with the Description box empty. I assume this is because the requery is clearing out the cbobox. The data however is still stored in the table and loads into the report just fine. I can live with this issue, But I wanted to know what I did wrong and what I can do differently to fix this and prevent myself from making the same mistake in the future.
I have attached a screenshot as well.
Can anyone provide any insight?