Auto Remebering Help

[bambi_]

Not really sure how to word this but here it goes;


Im wondering if it is possible to have the field auto remember things and compile its own list, so that when u type something it will detect, in the same way a look up field would do, but instead of entering the types first, having access remember as you go.

For instance, if i was doing a list of movies, and i didnt want to do a look up list of a million directors but rather have the database remember ones i have entered in forms as im going, to form a look up.

Does this make sense, is it possible?

[Bob Fitz]

If I've understood you correctly, then yes you can do that.
I would suggest that you use a combo box. Set it's Limit To List property to Yes. You would then need a little bit code to add new directors the table that populates the combo box. I'm sure you could get help with the code if you need it.

[June7]

Check out the NotInList event of the combobox. Review http://allenbrowne.com/ser-27.html

[bambi_]

I tried out the notinlist event but it doesnt seem to be wanting to work.
im using 2007 does that change anything?

[Bob Fitz]

I don't think it matters which version of Access you are using for the NotInList event. Can you show us your code that doesn't work.