Auto Selecting value in combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top