Results 1 to 2 of 2
  1. #1
    Perfac's Avatar
    Perfac is offline Expert
    Windows 10 Access 2016
    Join Date
    May 2016
    Centurion Pretoria

    Expression on main form to return entry in a field on the subform.

    For a year we didn't do any further developing but our system has more than 1300 objects now. We have a few forms with sub forms and all of them work. Today I battle a bit with something that works many more places in our system. Am I missing something? There is a field on the sub form that we need to return the value in a field on the main form. On the sub form we opened Page header and Page footer, we placed a text field in the footer. On the main form we have a field where we put in an expression to return the entry in the field in the sub form(in the footer). It returns an error and I didn't find why yet. Please answer the following.
    1. Is there a difference in placing the field in Page footer against Form footer?
    2. If I open the form header and footer on the sub form, the fields display in Lay out view, if I place the field in page footer, it does not display when I click on lay out view. Does this choice influence the reason why the field on the main form errors? My other forms with the same situation work and they have the page footer opened.
    2, If you understand my question, help me please.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Ive never used a page footer ever. The form footer is just fine.

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

Similar Threads

  1. Replies: 8
    Last Post: 02-22-2017, 10:38 AM
  2. Replies: 2
    Last Post: 12-09-2015, 04:50 PM
  3. Replies: 1
    Last Post: 06-27-2013, 09:33 AM
  4. Replies: 8
    Last Post: 05-30-2013, 05:06 PM
  5. Replies: 6
    Last Post: 08-24-2012, 12:04 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