problem with a subform

Posted on 2011-10-28
Last Modified: 2012-05-12

I have a subform that links the ids in two tables.  It used to work fine -- but now when the master form opens the one thing that comes up on the subform is a 'new' records (blank).  Or the Master file shows as a new record with all subform records.  There must be a setting that I am missing.

linked fields:
Master:              ID               = Project ID in tbl_Project
Subforms:         fkproject    = Project ID in tbl_ResourceRequest

Attached are sample tables and forms.

Thanks for your help,
Question by:aeolianje
    LVL 61

    Expert Comment

    In your subform's design, under the Data tab, you currently have the Data Entry property set to YES.  This is only for entering new records, not viewing existing ones.

    Change your Data Entry property to NO to see existing subform records.

    Author Comment


    Thanks for the reply.  However, I do want the ability to enter new records on the subform.

    LVL 61

    Expert Comment

    You will have that abilty with data entry set to NO. The problem with data entry set to YES is that it exclusively allows you to enter new records, nothing else. The property name is a little misleading.
    LVL 61

    Accepted Solution

    Have you tried it?

    The settings needed for your purpose are

    Data Entry = No
    Allow Additions= Yes

    That allows entry of new records while dispaying existing ones.

    Author Closing Comment

    LVL 61

    Expert Comment

    Glad that worked out :)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
    We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now