Sorted now - don't worry :)

[RobinL]

Add Item if not in table....

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

 

[FoFa]

That always sounds good, but then you end up with stuff like Mr. MR MR. Mr, MR, mr. mr, nr. nr,
it is usually better to have them check the selection, and if it is not found, allow them to add it via a command button and popup form.

 

[RobinL]

thanks yeah i take your point. I already have a validation system by which another tab loads up after you press 'done' and asks you to check the details. Not ideal, but it should be OK - the user is my computing teacher so he knows how to go into the tables and change stuff if necacery.

Thanks