Form_Load event: how to use??

[zozzie]

Hi,

I have a form that is used to enter data in a database (MSAccess).
In this form the user can select different listboxes and comboboxes and the selected values are then written to the underlying database after the user has clicked the 'update'-button.

Everything works fine, but I would like to 'refresh' the form to it's original state as it was loaded after the first startup. I don't know how to do this. I tried to call the form_load event because this contains all the initialisations, but it doesn't work.

Can anybody help me with this? Please give me a code example is possible.

Many thanks,

Tom

[Andy]

you need to reset each control back to the original state. You could make a routine that does that and when the user has made the final selection, call the routine in that control's event.

like this:

text1.text = ""
combobox1.text = ""
label1.text = "ready for another entry"

get it?

you just need to manually set them back like that.

It's a good idea to use a routine because that way, the user could select a button and force things back to default if he wanted to.

[zozzie]

Thanks Andy,

I wrote a sub with your suggestions in it. They work fine for a combobox and a textbox but not for a listbox because the listbox should show the default startup values. How can I do this.

PS: refreshing the form with me.refresh doesn't do the job.

Thanks

Tom

[Cander]

They work fine for a combobox and a textbox but not for a listbox because the listbox should show the default startup values. How can I do this.

By clearing it
ListBox1.Items.Clear()
and repopulating it the same way you did in the Form Load

[zozzie]

Thanks,

I'll give it a try.

Tom

[Andy]

here's some code I found at VBExplorer.com

Public Sub ClearAllText(frm As Form, ctl As Control)

For Each ctl In frm
        If TypeOf ctl Is TextBox Then
                ctl.Text=""
        End If
Next ctl
End Sub