Type Mismatch

A

Adam

I created a conditional macro to set the value of one option box choice to NA
(from Yes, No, NA), if another option box choice preceding it has the value
of No. I placed the macro in the Lost Focus of the Event Tab on the
individual options property sheet (not the option group whose control source
is the field that the value of that option chosen will be stored in). When I
tried to use the control group to accomplish this in the After Update
property on the Events tab i got a different error reading "control is not
available for automation" - any suggestions
 
S

Steve Schapel

Adam,

Can you please list the Actions, and relevant Arguments, of the macro you
are using?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Move Chart with Text 0
How to display zero value in blank fields of Cross Tab query 0
Type Mismatch with Option Group 1
Trying to populate data using a Macro 3
Word macro that can call cells out of Excel for a find and replace 0
Need some PWA help 0
Tab character in a Text Box 1

Top