Select Case in a Report

Good Day!

I am working via ODBC with a sql database.
what i want to accomplish is this:

there are drop-downs in the program running from the sql database, where the
user sees opt1, opt2, etc.
and when i look at the tables, i see 0,1,2,4,5,8,etc.
i know which titles belong to which numbers, and in a report i want the user
to see the title, not the assigned value. i can accomplish this witha
textbox and a slew if nested iif's, but it is hard to modify, time consuming,
etc.

i am trying to do a select case statement to take care of this:

sub Report_Open()
Select Case LOCATION (LOCATION is the field that has the assigned
number in it)

case "001"
location_display = "Name1"
case "002"
location_display = "Name2"
etc...

i keep getting an error message that states:
You have entered an expression that has no value

can a select case be done in a report?
is it something in my first line of the select?

TIA

~K

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200608/1

.

Relevant Pages

  • RE: Select Case in a Report
    ... The error message you are getting can be caused by a Null value or a field ... that the report cannot specifically identify. ... I am working via ODBC with a sql database. ... what i want to accomplish is this: ...
    (microsoft.public.access.reports)
  • Re: Building An Organization Tree From Records?
    ... My objective is to accomplish both, but primarily convert my source data ... "Nikos Yannacopoulos" wrote in message ... > a tree-like report, or convert your input table to a hierarchical ...
    (microsoft.public.access.formscoding)
  • Re: Detail Height
    ... explain in detail exactly what you are trying to accomplish. ... > I have report that I use print by VB Event / on Format ... > Dim Number, Words, TheRaw As Integer ... > Number = Len'strLast data coms from VB print ...
    (microsoft.public.access.reports)
  • Re: specify printer
    ... The specified printer is not my default printer. ... several ways to accomplish this goal. ... One simple ways to simply open up the report in design mode and then go page ... dim strDefaultPrinter as string ...
    (microsoft.public.access.macros)
  • Re: Procedure Variable Value
    ... what I'm trying to accomplish. ... Software" called "Label Saver" (a really cool application that I have been ... PrintCount As Integer) ... >>TIME I run the report, and it gets executed only once on subsequent runs. ...
    (microsoft.public.access.reports)