grid form with lookup column - easily adding a new row to the lookup

[vthomeschoolmom]

I have a really simple database for keeping a price book.
One of my forms is a Master form for ShoppingTrip with a subform for ShoppedItem. After I shop, I want to put all the items into the ShoppedItem for the ShoppingTrip. But if it is the first time I buy something, it will not yet be in Items. I don't want to have to zip over to Items, add the value, then refresh the drop down.

What would be the best mechanism for letting me enter values, maybe directly into the column, and have them added to Items? I am not wedded to any specific solution. Thanks

[June7]

That's what the combobox/listbox NotInList event is for. http://www.fontstuff.com/access/acctut20.htm

[vthomeschoolmom]

Woot. I never knew that. Now I do. Thanks. Is there a mechanism for marking your post as the answer? I don't see it.

[June7]

No, can just mark the thread as resolved with Thread Tools dropdown above first post.