[2005] Form Status...

Dear All,
Can anyone tell me how can I run a function or a sub from one form to another? :confused:

Let say I have a form that allow the user to enter information of an employee, (first, Last name, Add, and Department name etc…) the department name is a Combo box, that contain all the names of Department, if the user want to add new department he can press a button which load the Department form (different form). What I want is, when the user enters the new department and the User info form is loading, I want the Department list (combo box) in the (user form) to refresh and get the new list name of Department. “How can I do it?” I hope that I made it clear… :blush:

Appreciate any help…

Regards,

That's what data binding is for. You might have your Departments in a List(Of Department). You bind that List to your ComboBox. When you open the Departments dialogue and add a new Department you add it to that same List. You then call ResetBindings on the BindingSource and it will refresh the items displayed in the ComboBox from the List. It's this sort of thing that makes data-binding incredibly useful, despite some people's determination that it is inherently wrong (not you, someone else).

You can transer data between two forms by creating some properties on your first form so the second form can read and set it as needed. Then in your first form, when the second closes from being displayed with .ShowDialog, you can refresh the dataset that should be bound to your combo and read the forms property to see what was set from the popup form.