Booleans and Userform_initialize()

Ok this is driving me insane. What am I doing wrong?

In a module I have this:

Please Login or Register  to view this content.

Then in a userform called 'Admin1' I have this:

Please Login or Register  to view this content.

Then for each button on a UF called 'Admin' I have this (called Delete_click and Edit_click):

Please Login or Register  to view this content.

The idea is that whatever button is clicked (either Add, Edit or Delete) then a MsgBox appears with that message.

But it doesn't work?! Any ideas?

Hi Nathan,

Ahh yes that works, although only once? What I mean is that on the second form I have a button which takes the user back to the 'Admin' form (in case they wish to Add or Edit, etc).

Is there a reason why it only works once?

Thanks guys. Think I understand.

I put this behind the Add button:

Please Login or Register  to view this content.

But I get an argument not optional on the Unload.Me?

@Rory - where do I put your admin1 code? Which sub?

Should have said - all forms are ShowModal = False.

Hi romper,

Sorry I really am not getting this. 'Unload Me' just closes the form but doesn't show anything.

I have uploaded my project with irrelevant stuff stripped out. Can you help?

Hi Norie,

Thanks. I have this in 'Admin'

Please Login or Register  to view this content.

This in 'Admin 1' when the 'Back to Admin' button is clicked:

Please Login or Register  to view this content.

And this is also in Admin1 so that when it initializes I receive a MsgBox (so that I know it works). At the moment it only works once. Clicking the Back to Home button seems to be destroying something.

Please Login or Register  to view this content.

Hi Romper,

You have just saved my keyboard!! Thanks a bunch (and to everyone else!)

Thank you. : )