Type Mismatch

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
Access How to Validate the query parameter before loading the form that is based on the query iteself? 2
getting type mismatch 3
"Type Mismatch" error with search macro 2
Type Mismatch in Recordset sql 1

Back
Top