Results 1 to 2 of 2
  1. #1
    MasterPC is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2013
    Posts
    2

    Dlookup function to load information from table to another table using subform

    I have 3 table table; Invoice table, Product table and Sale_product table. Sale product table records all sale from the product table

    Invoice table has these fields
    ID
    TOTAL
    CASH_TENDERED
    CHANGE



    Product table has

    ID
    CODE
    QUANTITY
    NAME
    PRICE

    and Sale_Product table has these
    ID
    PRODUCT_CODE
    QUANTITY
    PRODUCT_NAME
    PRICE
    SUBTOTAL
    INVOICE

    I did main form from Invoice table and sub form from Sale_product table. I want to use DLOOKUP function to load the name and price, quantity and calculate subtotal automatically from the product table based on the product code entered.

    Kindly help me as this is new to me and i have being trying hard and i keep on getting "Name? error"

  2. #2
    MasterPC is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2013
    Posts
    2
    Click image for larger version. 

Name:	Relationship.JPG 
Views:	11 
Size:	94.8 KB 
ID:	11657Click image for larger version. 

Name:	Form and Subform.JPG 
Views:	14 
Size:	111.1 KB 
ID:	11658

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 05-09-2012, 07:20 AM
  2. Replies: 2
    Last Post: 08-22-2011, 09:02 PM
  3. Replies: 1
    Last Post: 08-13-2011, 12:03 AM
  4. Replies: 2
    Last Post: 08-01-2011, 11:35 PM
  5. Replies: 4
    Last Post: 09-03-2009, 02:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums