Notinlist Onthefly

[Propoflady]

Is it possible to have a combo box in your form, if the user types in a
name not in box, a box would appear this item not in list, would you
like to add and then when user clicks yes it would open form to add the
record?

all help appreciated

[Jens Schilling]

Hi,

Is it possible to have a combo box in your form, if the user types in
a name not in box, a box would appear this item not in list, would you
like to add and then when user clicks yes it would open form to add
the record?

all help appreciated

You could start here :

http://www.datadynamicsnw.com/accesssig/downloads.htm

Reading : Not In List - Detailed Instructions by Tom Wickerath

Within this document the following KB-article is mentioned:

http://support.microsoft.com/kb/197526/en-us

A code example is available here :

http://www.mvps.org/access/forms/frm0015.htm

And sample databases you can find here :

http://home.comcast.net/~cccsolutions/accesstips.html

http://www.databasedev.co.uk/downloads.html

HTH
Jens

[MGFoster]

Propoflady wrote:

Is it possible to have a combo box in your form, if the user types in a
name not in box, a box would appear this item not in list, would you
like to add and then when user clicks yes it would open form to add the
record?

Here's some URL's that describe how to use the NotInList event:

http://www.mvps.org/access/forms/frm0015.htm

http://www.blueclaw-db.com/access_no...ed_example.htm
Scroll down to see the code for this URL.

--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)