Search results

I have set the on focus to the the event and it works fine Doesnt Work - evertime I create new order the subform loads - gets focus and immediately makes an entry of the last product on the list It does goto the right spot in the details subform tho

I have a Main Form "SalesOrders" and a Subform "SalesOrdersSubform" - the subform is linked to the main form by "SalesID" no. I have a third form "PrevPurchases" which list the products that the customer has purchased in the past and is filtered from the Main form by the "ClientName" In the Past...

I thought this was a better way but it is obvious the wrong way - I have written an update query and it works Tks

If I get the totals counted by a query how do I then add the totals to the master

If they scan and count the stock on the shelf the total is in the file then when they get to the warehouse they can come accross the same item again so it is scanned and entered. The stock can be in up to three places.

I have a file with the stock in it set at zero I have a file with all the stock as it was counted - some items can be in the counted file more than once as they may have been in different places. I have started to write my code to update but have got lost in the middle I can collect all the...