I was planning on having a Total field in the Orders Table so I could call upon it throughout the database which is why I wanted to populate that field from the field in the subform.
I have decided to get rid of the Total field and I will instead calculate the total as and when I need it by adding line items in order details table as and when I need it.
I am finding Navigation forms frustrating at times as searching around...
mashman
Last Activity: Feb 16 '14, 05:49 AM
Joined: Dec 19 '13
Location: Perth, Australia
-
How do I update textbox on Mainform on close of dialog window?
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_orderdetail s
- 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... -
1) THANK YOU - You are correct this information is a really hard find. I must have read over 500 posts over the last 2 weeks trying to do this. I think they are all talking about the old Tabbed forms more commonly used in pre 2010 access.
2) GOOGLE SEARCH TIP =>2010 - I found Google was full of lots of pre Access 2010 clutter as it was near impossible to exclude using keywords, but if you use advance search and filter results only...Leave a comment:
-
Change Active Tab 2013 VBA
Hello,
I am using Access 2013.
I have Navigation Tabs when I click on a button in the form below the Tab I want to move to another Navigation tab.
I have been able to successfully Set focus from the command button in the form to the Tab I want, but I cannot get it to make that tab/page the one that is displayed.
...Code://navViewOrder is the tabs name I want to go to. //NavigationControlSales
No activity results to display
Leave a comment: