Refreshing form - please help

[scottappleford]

Hi

I double click a combo box which takes me to a new form. e.g. a purchase order form does not have an employee so they need to be added. When the employee form is closed i would like to refresh to combo box so the new employee appears in the combo box.

Please help

Thank you

 

[le888]

Not sure but try this. Put on the purchase order form close event:

Forms!name of your main form.name of your combo box. Requery

Le

 

[scottappleford]

Thanks that works for a control on the main form as i refrsh the form and the new employee shows in the combox box.

but i can not get the subform to refresh. also if the Purchase order form is not open when the employee form closes it causes an error. e.g. someone might want to see a list of employees or add one another way.

help appreciated

scott

 

[scottappleford]

me.refresh on the form using the on activate event.

that little bit of code took me all day to work out - sometimes things seem so hard and it is as simple as that.

i was opening form, moving focus, requerying, closing forms etc etc.

thanks