I have a form with several subforms. One of the subforms is for addresses. One of the subforms is for invoice data. The invoice data includes a drop down list in order to select one of the addresses in the adress subform.
At first I had to open and close my main form in order to get the list to update. Then I read about "Me.dropdownlist.Requery"
First I tried adding the code as an "AfterUpdate" command to the address subform but that didn't work, probably because I have the list on another subform.
So I tried adding this code directly as an "On Click" event of the actual drop down list. This works......sort of.
The first new address that I add to the form gets updated in the list but each address after the first one doesn't.
Why am I getting a result only on the first new address that I add?
Thank you for any light you can shed on the problem.