Dropdown List

G

Guest

o.k. I have created my Dropdown List with the wizard. It has 5 items.

1. How do I modify (i.e. add/delete) the choice list of items I have
created?
2. How do I get the item information in to my database after it is chosen
from the Dropdown List?

Thanks,

Kirk
 
G

Graham R Seach

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top