Look Up Table and Automatically Enter New Values

[qvqv]

Hi



If I have 'field table' holding last names, which I use to assist users to lookup last names when making a new entry into a sales table.

This works ok, but if the lastname is not in the 'field table', is it possible to allow the user to enter a new last name, and this to included in the 'field table'.

Many thanks

[Bob Fitz]

...which I use to assist users to lookup last names when making a new entry into a sales table.

I would use a combo box and use it's "Not On List" to add new names.

[accesstos]

You don't need a separate 'field table'.
Just get the unique values of the [LastName] of the main table as rowsource of the combobox and set the Limit To List to "No".

For example:

SELECT DISTINCT [LastName] FROM tblSales ORDER BY [LastName]

[orange]

qvqv,

Please tell us more about your business in simple plain English. You mention Sales and Lastnames --how do these relate?
What is your database used for?

[Bob Fitz]

qvqv

Attached is an example of my suggestion in post #2

[qvqv]

I dont have the option ""Not On List"" "Just I will type in the list I want" which is what I am using.

[orange]

You may find the video at this link helpful.

[mike60smart]

Hi
You are describing using the Wizard to create a Combobox whose Row Source is the Table that Contains the List of Lastnames.

Once the Combobox is created you would then use the Not In List Event to allow the user to add a Lastname to the List.