Refreshing a form on select of a combo box..?

[OllyJ]

Hi guys, hope someone can help me out here.

It's probably something really simple but i am struggling...

I have a form where the user has to enter a job number from a combo box. If they type a combo number that isn't in the list, I have used not in list to open the job form in data entry mode where they can enter the new job. When it has been saved and closed the other form remains open...

...I then need to somehow refresh the form so that the combo is updated straight away, any ideas??

I have tried the form: on activate; and the job number itself on got focus; before update etc and nothing seems to work.

I cannot refresh the form from code on leaving the 'add job' form as the original form is not always open at the same time as it and would produce an error if it was closed.

Thanks in advance, OllyJ

[minchazo]

I did something similar on a form of my own. Try adding this to the Form_Activate() event:

Me.ComboBox.Requery

Replace ComboBox with the name of your combo box