Kirk,
1. How do I modify (i.e. add/delete) the choice list of items I have
created?
That depends on where the combo gets its data from:
* If its RowSourceType property = "Table/Query", then you'll need to add
data to the relevent table.
* If its RowSource property = "Value List", you'll need to type the data
into the RowSource property, with each additional item separated by a
semi-colon ( ; 0.
2. How do I get the item information in to my database after it is chosen
from the Dropdown List?
* If the form is bound to a table/query, then select the appropriate
field from the combo's ControlSource property.
* If the form is unbound (the form's RecordSource property is blank),
you'll need to write some code to populate the correct table field. If
that's the case, let me know the following:
(a) The combo box's name
(b) The name of the table that contains the field you want to store
the valu ein
(c) the name of the field you want to store the value in
(d) the datatype (text, integer, long integer, date, and so on).
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html