[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 383
  • Last Modified:

problem with a subform

Experts,

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,
je
SampleData---Copy.accdb
0
aeolianje
Asked:
aeolianje
  • 4
  • 2
1 Solution
 
mbizupCommented:
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.
0
 
aeolianjeAuthor Commented:
mbizup,

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

je
0
 
mbizupCommented:
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.
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
mbizupCommented:
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.
0
 
aeolianjeAuthor Commented:
Thanks!!!
0
 
mbizupCommented:
Glad that worked out :)
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now