How to check if there is an input if an option button is Yes

Hi All

i have created a form and want to use MsgBoxes to highlight missing data i have the text and combo boxes done with the following code:

Please Login or Register  to view this content.

I currently have this for each item i am sure there is a neater way of achieving this but it works.

What i need to do now is check that a txtbox has been filled is an option button has been selected as Yes and to display a MsgBox if it hasn't.

So, if the Option Button has not been selected do you need to do any checks, or perhaps the user is not allowed to proceed?

Posting a code snippet out of context does not help to clarify things. Please describe the exact sequence and all possible outcomes.

It may be that the best thing to do is add the verification code to the 'OK' button (if there is one) but it would be best if you uploaded a sample workbook with your code as it stands.

Sorry

So there is a yes and a no option button that are grouped, what i want is if the yes option button is selected (no is selected by default) then something must be entered into a text box. So not been able to move on would be good as it is all my verification code is at the end when the person inputting the data presses the save command button

So in the picture if the yes option button was selected then i would require something in the Area Comb box and also something in the Abnormality txt box.

OK, I can't be specific based on an image but include the check

Please Login or Register  to view this content.

Thanks that works so i understand now how that works, this has lead onto another fault. I am using a multi page form so when i press the save command button once finished i get a run time error if the missing item is on a different page to the one i am currently on. Do i need to tell it to look at each form page?

It shouldn't and it's impossible to say why it does. Uploading a sample workbook that illustrates the issue is the only way to get positive answers.

I have up loaded the file and a screen shot of the error code, it appears to be with setting the focus back to the missed cell, it works if on that page and if you remove that line of code but will not work if you are on a different page.

I an opening the form using the command button on sheet 1 in the top left

You can't set focus to a control if it is hidden (as it will be if on an unselected page in a MultiPage control) - you'll have to select the correct page before setting focus to the control...