I am building in Access 2013
I am using Navigation forms.
My main forms is frm_orders
- It has the field (bound) txtOrderTotal
My subform is frm_orderdetails
- It has the (unbound) field txtSubTotal
My dialog form to add items to order details is frm_AddItem
- It has cboProduct, txtUnitPrice, txtQty
Currently working - When I add a new item in my popup form and save it adds the item to the subform and changes the txtSubTotal
What I can't seem to do on close of the frm_AddItem is take the txtSubTotal from the subform and place it in txtOrderTotal on the main form.
I've tried accessing the text box via normal method Forms!frm_order!txtOrderTotal and Me.txtOrderTotal but vba just throughs a wobbly saying it can't find the field.
Is it because I am using Navigation forms.