I have a form where i can enter a persons information. The company can be
selected through a dropdown list.
In case the company isn't already in the list, you can add it by clicking an
"add-button" right next to the combo box.
I used the requery function so that the new company appears in the list
immediatly.

What i would like to have is that every time I enter a new company through
this popup form, when the combo requeries, it should also select the last
entry so i don't have to go look for it between all the other company's

my apologies for my english

What you can do is put code on your pop up form where you enter the new
company. Like on the After Update Event of the NewCompany field:

Forms!frmMainForm!CompanyField = Me.NewCompany

Hope this helps.
Jackie

"Jochen" wrote:

> I have a form where i can enter a persons information. The company can be
> selected through a dropdown list.
> In case the company isn't already in the list, you can add it by clicking an
> "add-button" right next to the combo box.
> I used the requery function so that the new company appears in the list
> immediatly.
>
> What i would like to have is that every time I enter a new company through
> this popup form, when the combo requeries, it should also select the last
> entry so i don't have to go look for it between all the other company's
>
> my apologies for my english