How do I update a drop-down list?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to make some changes in a form, how do I add or subtract from a
drop-down list already created?

Thank you,
 
Some items can be added using the NotInList event. There are good examples
in the help files. Typically, thought the way to add or subtract items would
be to change the sql of the rowsource, then requery the combo box. The
AddItem method used in VB is not available except in later versions of
Access with custom combo boxes from the Office MSO controls.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
What is the Row Source Type - Table/Query, or Value List?

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Back
Top