Reloading a VB Form

[Gaff]

Is it possible to reload a form after it has been loaded initially. Is there some kind of refresh property perphaps?? I'm updating my database using the form and other details on the form are being retrieved from the database and i want to just refresh these details. Thanks.

 

[JohnYingling]

Try
Controname.Refresh
or
Me.Refresh

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort in VB or VBScript

 

[Nagrom]

Yes, forms have a "Refresh" method you can access via code.

Example: Form1.Refresh

This does not cause the form to actually "reload" though. It only causes it to be repainted. If you want to perform everything that happens in the Form_Load routine again then I suggest putting it into its own routine which you can then call in Form_Load, as well as at any other time you wish.

 

[mmilan]

If all the code that initialises your control in is an event procedure, you could declare the procedure as public and manually call it...

do Form1_Load

If you're working with DAO controls, they have a updatecontrols method that will automatically update all bound controls, if that's any good to you.