Need to automatically add new record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a somewhat basic Orders Database.
Customers, Products, Orders, Order Details, ...

I want to automatically add a record to Order Details for each Order as it
is closed.
i.e. upon closing I want to add a record:
OrderNum = Same that I was on
Qty = 1
Product ID = "ABC"

Any help would be appeciated.
 
What do you want to add to the record? What detail will you be adding after
the Order is closed?
 
I would be adding1 complete line to the order detail.
Qty, Item Number, Price....always the same item from a customers specific
product list
 
How about adding a Finish command button to the subform? Clicking it could
populate the current record with the required values by using something like
the following in the button's click event:

Me.Qty = 1
Me.ProductID = "ABC"

I don't know where "ABC" comes from, but if it is specific to the customer
the value could be in the customer record, and be contained in a hidden text
box on the main form. Instead of "ABC" you could reference the text box. If
OrderNum is the foreign key field then it is populated automatically upon
creating a new record.
If you specifically need to create a record behind the scenes and populate
it with specific data, I can't help.
 
Back
Top