Hey

I have a form set up to enter geological data for individual drillholes. All information on the form is referenced to a query.

On the form is a combo box listing the site name. The site name comes from my Site_Info table, which is linked by a one-to-many relationship to my Drillhole_info table (So one site can have more than one drillhole). I'd like to be able to add a site to the combo box as the user is filling in drillhole information, but the old 'Limit to List' has me stumped.

The combo box is set up to show the second column of the table (the site name), but is bound by the first column (the site identifier). I'd like to be able to type in the site name and generate the identifier.

Can someone point me towards an old post, a help file, or tell me how this works and how I can get around it!

Sorry if my descriptions aren't too hot - I no speaka the lingo good.

Thanks guys
Tommo

Explore the NotInList event... this article should help.