Combo Boxes

[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

 

[John Vinson]

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

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

 

[Tom Wickerath]

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