Unloading Form Throwing Error

Hey everyone,

Back at it again, I am up to loading in the data into the database but there is one error i can't get rid of.

i can't unload CheckForSongUserForm

I am unloading no different to before, i have tried unload me, nothing keeps giving me "object variable or with block variable not set"

If i hover over the CheckForSongUserForm it has an assign error, it seems to be treating it like a variable, i haven't set a variable with that name


Any help would be great

Thanks

Bensley

Place the code in the userform activate event instead of the initialize event.

Ah so you can't unload if your only initializing

how would i stop it showing the form behind, because now instead of a clean nothing shows unless there is an acutal match to go in the listbox, it pops up behind the msg box, and will load even if i turn msg box off with module1.FinishCheck

any ideas?