Adding Items to Combobox using event - OnNotinList

[campbellhatchard]

Wondering if anyone can help me.

I have the following tables in a Database

STOCK
[OrderNo] - (Primary Key)
[StyleNo]

RECEIVING_DETAIL
[ReceivingDetailId] - (Primary Key)
[ReceivingId] - (Header details Table)
[OrderNo] - (Combobox lookup to stock table)
[StyleNo] - (Combobox lookup to stock Table)
[Size]
[Units]

I use a form to enter receiving data into the tables. What I am looking for is an OnNotinList coding to enable me to add new Stock items without having to close the receiving form and add in the "Add New Stock Item" form.

I have no idea where to start on this one. This is my first real push into a more detailed database creation. I also would like to have a message box pop up to prompt the user to confirm the addition to hopefully negate typing errors.

Many thanks in anticipation

Campbell

 

[AyJayEL]

Try looking in FAQs faq181-0 there are a couple of notinlist faqs under Forms that look good as a start! Learn something new every day *:->*