how to refresh data on a form linked to a combo box 1

[Heeeeelp]

Hi Everyone,

I have a Customer form with a combo box that stores company names. If there is a new customer, the user clicks on the add customer button which opens a new form to input the information for a new customer. When the Add Customer screen is closed, the combo box on the Customer form displays the name of the new customer that was added to the database. However, if you select the new name in the combo box, the remaining fields on the form do not change to reflect the new customer's information unless I close the customer form and open it again. Please advise as to how I can refresh the form to reflect the new customer's information without having to close the form and opening it up again. I tried adding a refresh button to the form but this did not work.

Thank you in advance for your help.

Regards,
Tess

 

[ProgramError]

use me.requery in the afterupdate event of the combobox and onclose event of the new contact form.

Ian Mayor (UK)
Program Error
Always make your words short and sweet. Because you never know when you may have to eat them.

 

[ProgramError]

Sorry the onclose event should be forms!mainformname.requery because the new contact form still has the focus.

Ian Mayor (UK)
Program Error
Always make your words short and sweet. Because you never know when you may have to eat them.

 

[Heeeeelp]

Thank you, problem solved! I appreciate your help Ian.