Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. visage

    updating field data in one form, from another form

    Thanks Frink, Thank worked fine. Cheers for all your help.
  2. visage

    updating field data in one form, from another form

    Hi Frink, To answer your questions Is your Sent table called Sent? - yes Does your sent table have a Qty_Sent field? - yes Does your sent table have a Returned_qty field? - yes Does your sent table have a Product_Code field? - yes Is it a Number type? - no Does your Orders form have a...
  3. visage

    updating field data in one form, from another form

    Hi, I have this as the control source for the free field =[Qty_Received]-DSum("Qty_Sent","Sent","Product_Code=" & [Product_Code])+DSum("Returned_qty","Sent","Product_code=" & [Product_Code]) Thanks
  4. visage

    updating field data in one form, from another form

    Hello, You were right. Both tables do have a product id, known a product_code. In Order table - product_code is the primary key, but in the Sent table, a field called Sent_no is the primary key. But product_code does appear in tblSent. The tables are linked through the product_code. I pasted...
  5. visage

    updating field data in one form, from another form

    The Form - Order holds the product information. The form - Sent - holds customer orders. Thus each customer order (record) must impact on the free stock value, as it must reflect the true free stock value. SO how do I tell it to read each record and amend the free value where necessary...
  6. visage

    updating field data in one form, from another form

    I have two forms : Order and Sent. Sent is a subform of Order, and is in datasheet format. I have two fields in Order : Qty_Received and Free and two fields in Sent: Qty_sent and qty_returned. My problem is this - I want to use the calculation, Qty_Received - Qty_Sent + qty_returned, so me...

Part and Inventory Search

Back
Top