Results 1 to 2 of 2
  1. 02-21-2014, 06:58 AM #1
    masond
    masond is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2012
    Posts
    12

    Changing iff into VBA code


    Hey guys

    How can i write the following (See below) as Vba Code ?

    Channel: IIf([Sub-Source] Is Null,[How did you hear of us],[Sub-Source])
    Reply With Quote Reply With Quote
  2. 02-21-2014, 08:28 AM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Try: IIf( IsNull([Sub-Source]) ,"How did you hear of us",[Sub-Source])
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Changing order by using code
    By FRAZ in forum Queries
    Replies: 4
    Last Post: 01-22-2014, 12:54 PM
  2. ComboBox Code Selction for Activation of a field fliter code requesting Query
    By justphilip2003 in forum Programming
    Replies: 1
    Last Post: 05-04-2013, 12:19 PM
  3. Changing Printers Code produces an error
    By Perceptus in forum Programming
    Replies: 4
    Last Post: 01-15-2013, 08:33 PM
  4. changing OrderBy in code affect 3709 runtime error
    By xseper in forum Programming
    Replies: 8
    Last Post: 04-03-2012, 12:00 PM
  5. Need Help Changing Existing VBA Code to an event procedure
    By MsGeek in forum Programming
    Replies: 4
    Last Post: 05-18-2011, 03:24 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums