Add item if not in list?

[RobinL]

I have a table called tblLookupWizardOptions

It basically contains values like 'Mr., Mrs., Ms, Miss' etc in one field, and educational authorities in anther field etc.

Basically the table acts on various form to give defaul values that you can pick from combo boxes.

The problem is that the lists may not be complete. I want the user to either select a value or type one. The typed value then needs to be added to the lookupwizard table if it is a new value (as well as whatever table(s) the form is being used for).

I open the recordset for the table. Now, how do i search the table, and add a record if no value is found matching?

Thanks

Rob

 

[Jack Cowley]

This article will answer your question.

hth,
Jack