I am a newbie so excuse me if I use the wrong words.
I have a form with sub-forms see attached screen shot. I use an unbound combo box to select "Find Beneficiary" that is "DName" from a table/query. The following SQL is the row source for the combo box.
SELECT tabBenef.DName
FROM tabBenef
ORDER BY tabBenef.[DName];
All works OK except for one problems.
When I move to a different record using the record navigator arrows at the bottom of the screen the combo box displays the old name. See second screen shot.
I have tried to requery the form and also the combo box with no joy. The "DName" tracks correctly but the fact that the combo box does not agree with the DName field is somewhat confusing.
Any suggestion on how to blank out the name in the combo box or make it display the correct DName?
Since the SQL query does not have a name, I can not re-run it.