Auto Selecting value in combo box

J

Jochen

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
 
J

Jackie L

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
 
Top