Form Values to Table & Updating Calculated Fields on Form

[total13]

I am stuck trying to figure out how to get data entered into a Form (frmOrderForm) to transfer and be saved into a Table (tblCustomerOrders). I am aware that I built the Form prior to the Table and currently the fields are Unbound. However, when I tried to make them Bound to the Table, the values in the first group (OrderLine1) would duplicate in the next groups (OrderLine2 and OrderLine3). This duplication would also happen if I updated values in OrderLine2 or OrderLine3. In other words, all OrderLines would update to whatever OrderLine was last updated, which is not what I want to happen. I want each OrderLine to be independent from the others.

Basically, what I'm trying to do is enter orders into frmOrderForm and have them save to tblCustomerOrders. On tblCustomerOrders, each InvoiceNbr could have up to three rows associated with it based on the number of OrderLines entered into frmOrderForm and each OrderLine would have its own row on tblCustomerOrders. Am I missing something simple or would a different design suit what I'm trying to do better?

One other issue that I am having on frmOrderForm is getting the txtbxTotalApproxPcs and txtbxSubtotal to continually update as form entry is taking place. Currently, all three OrderLines need to be completed before these fields will update (probably because they are calculated sums of other calculated fields). This is not how I want it to work, though, because a customer may order one OrderLine. I tried to write expressions to trigger the update of these fields after txtbxLineApproxPcs1 and txtbxLineTotal1 were updated but it didn't work.

I am fairly new to Access so there may be a number of issues with my Forms and Tables that I am not aware of but any assistance or direction is greatly appreciated. Feel free to ask me for more details.

Many thanks in advance!

Also, this is my first post to this forum so feel free to inform me if I've done anything incorrectly.



Database - 2012.03.26.zip

[June7]

Can't have multiple 'order lines' like that. Remove two of the sets.

Can't do totals like that either. Remove those textboxes.

You don't want to repeat the customer info on each line.

Need a table of customers and a table for orders and a table for order details. Review this tutorial http://forums.aspfree.com/microsoft-...es-208217.html

and this http://office.microsoft.com/en-us/ac...010098674.aspx