Forms!myMainForm!MyControl = Me.MytxtControlUpdated
!MyControl ? Is this refering to the field I want to update if so do I include this line of code for each of the 12 fields that may possible be updated from the summary form.
MytxtControl refers to ?
One other thing when I open the summary form I am not able to edit the information that is displayed. is this just a matter of changing on of the properties of the form..
My Problem,
I am trying to create a form that displays a summary of data relating to a current record. I use a command button on the main form to open the summary form. Once in the summary form I would like my users to confirm the info is correct and if not make changes to the data while in the...
Thanks Mac and Terry, your help has been greatly appreciated, It makes it alot easier to understand when laid out the way you guys have thank you again.
Sorry one other thing that should be said is that the WeeklySales tables contains data from many different weeks.
All I neeed to update to the Products table are the items that have been sold during the latest date on the Weeklysales table.
The suggested methods want to update all records to...
Just need a little more info if possible:
Isn't the method you mentioned going to create a new field named Qty.
Should this expression be entered into an update query if so what is the destination and how should it be entered.
Thx again Mac..
I have entered as suggested but still no go. The table I am trying to update (Products) has the following fields - Product, Productcode, Costprice, Quantity, CompanyNum.
The Table I am trying to draw the data from (WeeklySales) to update the Products table has th following fields - Lastdate...
The problem,
For hours I have been trying to update a particular column in a Product table (Quantity). I run a query that groups all sales from the week and appends then to a Weekly Sales Table, I am then trying (everything) to update the quantity column in the Product table so that it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.