Type Mismatch

N

NetworkTrade

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

Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
'Type Mismatch' error message 4
"Paper Size Mismatch" error ... but not 1
Data type mismatch 1
getting type mismatch 3
Multiple IF Statement in Word 5
Conditional Expression - Type Mismatch 0
Type Mismatch 1

Top