Data entry on the fly

[isons via AccessMonster.com]

Hello Everybody!

I have a database containing tables Customers, Orders, Quotations, Suppliers
etc.

Fields in Orders tables are

OrderID
Date
PartNo (Lookup field)
Description
Price
Qty etc

PartNo field is a lookup field from products table. In my order entry form
when I enter Part No it lookup data in the products table and fills the form
with relevant data. If PartNo is not found in products table it displays
error message. I want to fill new entry on the fly in orders table and at the
same time I want my products table be updated with the new entry as well.

Please help

 

[BruceM]

You could use the Not in List event of the combo box to open a pop-up form
for entering the new information, then requery the combo box when you close
the pop-up form.

 

[isons via AccessMonster.com]

Dear Bruce,

Many thanks for your prompt reply.

I will fix the problem as you mentioned.

Best regards,

isons

You could use the Not in List event of the combo box to open a pop-up form
for entering the new information, then requery the combo box when you close
the pop-up form.

Hello Everybody!

[quoted text clipped - 20 lines]

Please help