Control Source Expression is too Complex

Tech-Archive recommends: Speed Up your PC by fixing your registry

I am using =Choose() command to display only current users of my database.
This allows me to limit the drop-down list of current users only while
keeping the records of past users intact. This has worked well, until now.

Apparently, there is a limit to the number of values for the "choose"
expression. When I tried to had the name of a new employee to my expression
in the control source, I got the following error:

"The expression you entered is too complex."

Can someone please help me to simplify the expression? It is simply
=Choose([Requestor],"Name1","Name2",..."Name27","Name28"). Once I add the
29th name and tab to the next field, I get the above error. Thanks in
advance.
.

Relevant Pages

  • Re: [OT] news providers
    ... "list overview.fmt" command it will display the fields in the overview database, ... I rarely read top-posted, over-quoting or HTML postings. ...
    (comp.sys.mac.system)
  • Re: yp command to print all server settings
    ... > information from the YP database. ... > display. ... I can't remember the command. ... > provide the syntax also? ...
    (comp.os.linux.networking)
  • indexes count for each table?
    ... does anyone know a good select statement or one command line to display ... indexes count for each table in a database? ...
    (microsoft.public.sqlserver.programming)
  • yp command to print all server settings
    ... Last week I stumbled on a command that displays all the YP server ... information from the YP database. ... display. ... I can't remember the command. ...
    (comp.os.linux.networking)
  • RE: Userform to add and update a table
    ... One of the most common scenarios in application development is to display ... the walkthrough illustrates many of the basic ... Access to a server with the Pubs SQL Server sample database. ... Creating the Windows Form. ...
    (microsoft.public.sqlserver.programming)