Adding values to the lookup list from within the form

[mfd]

I have a question. Go easy on me, I'm a complete novice.



I want my form to have a lookup field where I can type some text in and it will autopopulate the field based on previous entries in that field. So if I typed in a person's last name that was previously entered, it will finish it for you as soon as you type in a few letters, or give you several options based on the first few letters. And if the name was not previously entered, will allow you to type in the name and it will be included for future entries. Hopefully I explained that logically. Seems like there should be an easy way to do this, but I can't figure it out.

Thanks in advance,

M

[June7]

Use a combobox with AutoExpand property set to Yes.

Is this to input search criteria or to input data into record?

Options for source of the combobox list items could be a lookup table or the field the data is saved in.

If the lookup table is used, set the LimitToList property as Yes and will need VBA code behind the NotInList event to create new record in the lookup table.

If you want the combobox to just assist users with input but allow any text, set LimitToList as No and the RowSource could simply be:

SELECT fieldname FROM tablename ORDER BY fieldname;