Nesting Forms

A

AndreasO

Nesting Subforms

MainForm with 4 Subforms (1-4)
Subforms are all in a tab control
Subform4 contains another subsubformA

Records of Subforms (1-4) are linked to Mainform by ProjectID
(Child-Masterfield….)

Its works great so far, but (the nested sub…)

Subform4 contains records of TasksID
subsubformA contains TrtmntID

Subform4 is linked to subsubformA by TaskID (Child-Masterfield….)

subsubformA contains TrtmntID only (no more ProjectID)

That makes TrtmntID show up on all ProjectID’s

What am I doing wrong?

I can auto# the TaskID, making it unique for every ProjectID and it works,
but its not really nesting….
Do I need to create a query containing both tables and adjust join properties?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Press one button to execute another one 4
Someone stop my subforms from requerying 1
subform code question / additional advice requested 5
Automating datasheet/form view switch in subforms? 0
Relationship with a Primary Key? 4
Web Browser Progress Bar 1
Access 2007 conversion subforms don't display linked records 2
Using Linked Combo Boxes with a subform 1

Top