More trouble with Excel forms

[ninash]

Hi Guys,

Is there a way of refreshing data in a form if the original data has changed.
eg. I have 2 user forms the first one displays information concerning the address of a client and also has a command button to open a second form that allows the user to change that information. However on exiting this form the original form still holds the old data.

I have tried to repaint the form but still the data refuses to update.... I am getting a little worried as this minor macro is now very late.

Thanks in advance

 

[AncientTiger]

Where is your data being housed? In the spreadsheet somewhere? If so, you could use an onChange event to update your form....

 

[ninash]

Thanks I worked it out
While the second form had focus on the field in question I made a call to the other form to update it's own value. so when I return to the other form the values are correct.

Thanks for the suggestion but in the end it was just push it through and nothing as nice as a simple refresh on a form as you can do in full Visual Basic.