Klutzz said:
I am using a drop-down list for users to make a selection in a form with
results sent to an access DB. Is there a way to import a list to update
the
info available to the list or must all the entries be made one at a time
via
the form fiel properties box ??
An advanced way to do this would be to populate the drop down list from a
database - all you do is create a database results region, and use the
option to have the drop-down box, rather than the standard table format for
the results area. Use that results region within the form, and it becomes
one of the fields of your form, from which people can select the
information. However you still need to enter the data in the database
anyway, so it may not save you much time.
What kind of information are you needing in the drop down box, that you need
a quick import method eg country list or US/states list (two common
examples)? There are resources on the 'net that provide the HTML of these
'ready made' elements, that you simply can copy and paste into your
code/form on your page.
For example:
http://javascript.about.com/library/blcountry.htm has an easy 'wizard to
create the code for a drop down to select a country; This one lists the 50
states of the USA:
http://lab.artlung.com/50states/
Simply copy and paste the HTML into the place in your form (code view) where
you want this field to be.
Hope this helps. Note these are specific examples, but you would
otherwise need to enter each item in the drop-list separately if the
information is not to do with selecting country or states.
