Results 1 to 2 of 2
  1. #1
    offie is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Posts
    176

    Question Checkbox and IIF to set criteria for a field help

    So I have a field where the values start with either 4 or M and I want to be able to check which ones I want in a form, so far I have



    Like IIf([Forms]![COSum]![4Check]=True,"4*",Null) And IIf([Forms]![COSum]![MCheck]=True,"M*",Null)

    but it doesn't seem to workm, what am I doing wrong?

    Thanks!

  2. #2
    offie is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Posts
    176
    Nevermind,

    Like IIf([Forms]![COSum]![4Check]=True,"4*",Null) Or Like IIf([Forms]![COSum]![MCheck]=True,"M*",Null)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Using A Checkbox For A Text Field
    By LanieB in forum Forms
    Replies: 1
    Last Post: 04-12-2013, 06:18 AM
  2. Replies: 1
    Last Post: 03-27-2012, 04:49 PM
  3. compile a field on checkbox selection
    By jsabina in forum Forms
    Replies: 3
    Last Post: 01-06-2012, 01:12 PM
  4. using checkbox as iif criteria
    By TheShabz in forum Queries
    Replies: 3
    Last Post: 01-18-2011, 05:10 PM
  5. Replies: 7
    Last Post: 11-26-2010, 07:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums