Type Mismatch

G

Guest

have a Macro to OpenForm with condition: [checkbox] = 1

returning a "Type Mismatch" error message.....the checkbox is inside an
OptionGroup

have tried alot of different values - but can't seem to figure out why this
doesn't work
 
S

Steve Schapel

NetworkTrade,

The macro Condition needs to refer to the value of the Option Group, not
the value of the Checkbox. Should be like this...
[NameOfOptionGroup]=1
.... which will be true when the checkbox, whose Option Value is 1,
within the option group, is ticked.
 

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

Data type mismatch 1
Type Mismatch 1
checkboxes & command button 5
Type mismatch 3
DLookup Problem 2
getting type mismatch 3
"Type Mismatch" error with search macro 2
Ccreate Macro with MsgBox. Pls. help! 7

Top