[thelist] Access List query

[Andrew]

this is very useful thank you

Andrew

>-----Original Message-----
>From: thelist-admin at lists.evolt.org
>[mailto:thelist-admin at lists.evolt.org]On Behalf Of Ed McCarroll
>Sent: 15 October 2002 21:54
>To: thelist at lists.evolt.org
>Subject: RE: [thelist] Access List query
>
>
>Andrew,
>
>There is more than one way to do it -- you can set up a table as
>you inferred, or you can simply type in a list of possible values.
>The other way is to design a VBA function that supplies all the
>values, but most people find that way far too complex.  If you
>choose the former, I'd set up the underlying table first.
>
>The simplest way to go is to use the List Box Wizard.  If you
>select the list box item from the Toolbox palette, and then use
>it to draw a rectangle in the location where you want to put the
>list box, this wizard will come up and walk you through the
>process.
>
>You might want to look at the combo box, instead of the list box;
>it is often what people really want.
>
>BTW, the reason I answered your first inquiry as I did was because
>you did not clearly state what you were looking for.  I know what MS
>Access is, but there are many kinds of "resources" and "access" on
>the Internet, and because you did not really ask a specific question,
>it was not clear that you wanted technical advice.  In fact, I was
>hoping you were looking to hire a "resource"ful Access programmer.
>(I'm available.)
>
>Best of luck,
>
>  Ed
>
>- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>Ed McCarroll                          MailTo:Ed at ComSimplicity.com
>dba ComSimplicity                                  (310) 838-4330
>- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>
>
>> -----Original Message-----
>> From: thelist-admin at lists.evolt.org
>> [mailto:thelist-admin at lists.evolt.org]On Behalf Of Andrew Maynes
>> Sent: October 15, 2002 12:13 PM
>> To: thelist at lists.evolt.org
>> Subject: [thelist] Access List query
>>
>>
>> First question :)
>>
>> I have a field that I want to use as a list box, so the selected value can be
>> selected.  Presmably I need to make another table with the values
>and options in
>> it?  If this is the way forward what would I be poutting in the 'row source
>> type'?  The name of the table?
>>
>> Andrew
>> ---
>> Outgoing mail is certified Virus Free.
>> Checked by AVG anti-virus system (http://www.grisoft.com).
>> Version: 6.0.400 / Virus Database: 226 - Release Date: 10/9/02
>>
>> --
>> For unsubscribe and other options, including
>> the Tip Harvester and archive of thelist go to:
>> http://lists.evolt.org Workers of the Web, evolt !
>>
>
>--
>For unsubscribe and other options, including
>the Tip Harvester and archive of thelist go to:
>http://lists.evolt.org Workers of the Web, evolt !
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.401 / Virus Database: 226 - Release Date: 10/9/02
>