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
aeolianjeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
aeolianjeAuthor Commented:
Thanks!!!
0
mbizupCommented:
Glad that worked out :)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.