Combo Boxes

  • Thread starter Thread starter Kelly
  • Start date Start date
K

Kelly

In Access97 how do I get a combo box to let me enter the
data and add it to the list for recovery later. Help files
say to use the NotInList function which looks like it
requires code or a macro. Being a newbee this is beyond my
abilities so any help will be much appreciated.
Thanks...kbe
 
In Access97 how do I get a combo box to let me enter the
data and add it to the list for recovery later. Help files
say to use the NotInList function which looks like it
requires code or a macro. Being a newbee this is beyond my
abilities so any help will be much appreciated.
Thanks...kbe
Click to expand...

Well, you DO need code... but it's not all that difficult, and can be
a good introduction to using VBA. For a fully worked out example
see The ACCESS Web article

http://www.mvps.org/access/forms/frm0015.htm
 
Yes, you will need to use code. This is not something that can be done with macros.

See the second download at http://www.eade.com/accesssig/downloads.htm
The sample database is an Access 2000 database, but the code used is shown in the Word
document.

Allen Browne also has a method available:
http://members.iinet.net.au/~allenbrowne/tips.html

Using the NotInList event (combo)
http://members.iinet.net.au/~allenbrowne/ser-07.html

Tom
_______________________________


In Access97 how do I get a combo box to let me enter the
data and add it to the list for recovery later. Help files
say to use the NotInList function which looks like it
requires code or a macro. Being a newbee this is beyond my
abilities so any help will be much appreciated.
Thanks...kbe
 
Back
Top