Stop Button Working Before Form is Complete

[y2drew]

Hey

Hopefully someone can help me with this. I'm very new at VBA and am kind of muddling my way through

I have some code to make the SUBMIT button selectable only after one of the Option boxes (client/agent) is filled, but I also have a username drop down box (user) and two other drop down boxes (calltype and details). How can I make it that the SUBMIT button doesn't work until ALL fields are filled? The code is below for what I already have and attached is a look at the form.

Clipboard01.jpg

Any help with these would be greatly appreciated...I'm pretty stuck. If you need any further clarification, please let me know.

Apologies if the code is ugly...I'm new to all this!

SUBMIT button code:

Please Login or Register  to view this content.

[y2drew]

Thanks tigeravatar! Apologies, missed that bit

[royUK]

Is Client declared as a Boolean Variable or is the name of an Option Box or CheckBox?

The enabled will only be true if Client is True

[y2drew]

Client is the name of the Option Box.

So I'd need it to be a Bootlean Variable to give what I want. Any advice on how to go about this?

[abishekmouli88]

Hi,

If you can attach a sample workbook, I can do that for you

Thanks and Best Regards,
Abi

[y2drew]

That would be great, thanks Abi!

[royUK]

Try this

Please Login or Register  to view this content.

[y2drew]

Hey!

This seems to almost work, the only thing is that if you select one of the option boxes and then fill in the rest, you have to change the option box again for the "SUBMIT" button to work.

I've attached a copy for testing.

Thanks for the help!

[royUK]

The way you have the form set up you will need to click the option again. I can't really see why you have two option boxes.

Please Login or Register  to view this content.