Results 1 to 4 of 4
  1. #1
    thudson is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2013
    Posts
    6

    Form is blank except for Header & Footer?

    I am trying to create a form which I will use as an Invoice. It uses 3 tables and has a sub form which I call Orderline, in which I can add multiple part numbers and extracts by the part number the price and description from the Parts table and the quantity I enter for the part then using an expression gives a total for the line.


    This is the SQL output for the Query:


    Code:
    SELECT tbl_COrders.OrderNo, tbl_COrders.fkCustomerNo, tbl_COrders.OrderDate, tbl_COrders.PartNo, tbl_COrders.OrderQty, tbl_Customers.CustomerNo, tbl_Customers.CustomerFullName, tbl_Customers.CustomerStreet, tbl_Customers.CustomerCity, tbl_Customers.CustomerRegion, tbl_Customers.CustomerPostCode, tbl_Parts.PartNo, tbl_Parts.Part_Description, tbl_Parts.SalePrice, tbl_OrderLine.LineID, tbl_OrderLine.fkOrderNo, tbl_OrderLine.fkPartNo, tbl_OrderLine.OrderQty, tbl_OrderLine.LineTotal
    FROM (tbl_Customers INNER JOIN (tbl_COrders INNER JOIN tbl_Parts ON tbl_COrders.PartNo = tbl_Parts.PartNo) ON tbl_Customers.CustomerNo = tbl_COrders.fkCustomerNo) INNER JOIN tbl_OrderLine ON (tbl_Parts.PartNo = tbl_OrderLine.fkPartNo) AND (tbl_COrders.OrderNo = tbl_OrderLine.fkOrderNo);
    When I open this form all I get is the Header and the Footer and just a blank page. No error messages are shown, so I don't know why it does not display the form(s).

    Can anyone see why the form items are not being displayed. I have been trying different ideas for hours and can't find the solution.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    can you try making the master form using 1 table: Orders

    then the subform is bound to tOrderLIne (the details of the order ,right?)
    be sure to bind the subform.OrderID to Masterform.OrderID

    tCustomer does not need to be there, it is only a lookup for the tOrder.Customer field.

  3. #3
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    You mean no controls or fields are there? Perhaps because of

    http://allenbrowne.com/casu-20.html
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    thudson is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2013
    Posts
    6
    It was a stupid error on my part! Does help if there is some data in the record your looking at!!

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

Similar Threads

  1. Form Header/Footer Vs. Page Header/Footer
    By Tuckejam in forum Forms
    Replies: 2
    Last Post: 04-09-2020, 10:14 AM
  2. Problem wth form header/footer
    By UT227 in forum Forms
    Replies: 4
    Last Post: 09-12-2016, 07:27 PM
  3. Form view header and footer not seen
    By Lou_Reed in forum Access
    Replies: 5
    Last Post: 01-04-2016, 03:39 PM
  4. Referencing Objects in Form Header/Footer?
    By thadius856 in forum Forms
    Replies: 3
    Last Post: 08-16-2015, 04:36 PM
  5. Header and Footer
    By tcheck in forum Access
    Replies: 1
    Last Post: 11-08-2012, 02:23 PM

Tags for this Thread

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