Add new item to combo box?

[John Bildy]

I have a small database to keep track of orders for a nursery.

The products are catergorised. I.e. A category field and productname field.

I have set up a form for "customer orders" with an "orders detail" sub
form - product, qty, etc.

I want the option to add a new product if it's not in the list. (Not in list
event.) I'd like the "products' form to open so I can add new product and
for the "orders" form to then refresh to show updated info.

Can someone please provide me with some simple code to accomplish this
please. Thanks.

 

[Van T. Dinh]

See Access VB Help on the NotINList Event / Event Procedure.

Also see The Access Web article:

http://www.mvps.org/access/forms/frm0015.htm