Won't let me complete new [Order_item] recordn ??

[Will]

My Order_Items are in a sub form on my Orders_Form

Once I start to enter an Order_Item... if I enter each field without moving
the cursor to another Order_Item on the Order it works fine.

If I start to enter an Order_Item... say the 2nd item on the order... and I
enter Qty... then... before I enter the date I move the cursor to the date
field of the previous order item & copy it...

Now when I return to the 2nd order item 'date field' to paste... it won't
let me enter any more data into the Order_Item record.

I think this is because by not entereing any data into the field the related
table doesn't get populated...

But... How do I fix it so this won't happen?

Is there a way for the client to start entering an Order_Item... enter a
couple of fields... then click somewhere else on the form... then come back
to complete the remaining fields of the Order_Item?

Now we just have to delete the unfinished Order_Item record... must be a
better way.

thanks for any help.

Will

PS my (simplified) tables are...

Customer Table
idCustomer
Company
Contact Info

Order Table
idOrder
idCustomer
Order Date
PO Number

Order_Item Table
idOrder
idProduct
idShipment
Qty

Produts Table
idProduct
Product Name

Shipment Table
idShipment
idShipper
Ship Date
Container Number

Shipper Table
idShipper
Shipping Company
Contact Info

 

[German Saer]

Place a button to open a dialog form and do whatever you need to do in that
form.


--
___________
Thanks,

German Saer
Orlando, FL