updating a drop down list

[MissVinegar]

I have a form where you pick a course name from a drop down list. Next to it I created a button that opens for a form with courses names where you can add a new one. Then I save the new course name and close the form. The thing is - the new name doesn't show on the original drop down list until I reopen the form. Is it possible to do something that it actually appears straight away?

[Robeen]

You can try using Me.Requery - on the Form when you want all the new data to be available.

That should refresh all the controls on the Form and pull in the new course.

For information on this command, there is a good description here:
http://office.microsoft.com/en-us/ac...56400.aspx#BM4

I hope this helps!!

[MissVinegar]

Robeen,
Thanks for the link. I tried adding the code but it doesn't work. It work's when I clik SHIFT+F9 but this is not good enough...

[Robeen]

Where did you put the code?
In what Event of which Form?

[orange]

What exactly does this mean? but it doesn't work

[Robeen]

Try this:

 
Me.Your_ComboBox_Name_Here.Requery

[MissVinegar]

What exactly does this mean? but it doesn't work

It means that the new entry doesn't appear it the drop down on the main form. And it does after pressing SHIFT F9.

[MissVinegar]

Try this:

 
Me.Your_ComboBox_Name_Here.Requery

Robeen,
First I put it on the main form / form properties / on got focus and it wasn't working but now I put your new code with the combo box name in the combo box properties and IT DOES THE JOB! Many thanks.

[Robeen]

I'm glad I could help! All the best!