I have a subform on a tab/Page but it doesn't align with the records from the main form

[Duncan Pucher]

Forum Users,



I created a form/subform called "AlertChartingResidenttblfrm" and "AlertChartingsubform" and copied to a tab/Page. I want the records in the subform to relate to the records in the main form called "frmResidents" however when I move to a record in the main form the records in the form/subform don't change. Another user setup a tab/Page called "AlertDSN" that does function like I want it with a lookup for the resident name and a count of records "txtrecordno" in the subform. Could someone help me to know how to make the subform records relate to the main form records and show the count of records in a textbox?

Your help is appreciated,

[June7]

Looked at AlertChartingResidenttblform and its subform. Normally a form should do data entry/input for 1 table. Observations is not a field in AlertChartingtbl and should not allow edits to that field from this form. Set Locked Yes and TabStop No.

Master/Child Links properties are not set for subform container control holding AlertChartingResidenttblform. Maybe AlertChartingtblSubform should be directly on Tab page.

frmResidents doesn't show RecNum field in the RecordSource query in Design view but the wildcard shows in SQLview so this makes all fields available. A little confusing.

[Duncan Pucher]

June,

I agree about the observations field and will check the item for not allow edits, skip and lock.

Maybe I am missing some step. I added the form with the subform to the Tab/Page and then removed the fields in the form leaving the subform. Alternately I tried adding only the subform but had the same problem. I'm not sure where I would set the Master/Child Links properties for the form/subform. Where do I set this? I need to filter records like the records were filtered for the Tab/Page "Alert-DSN" but not sure how to get there. Any help would be appreciated.

[June7]

Select the subform container control and set its Master/Child Links properties, same as done for Alert-DSN.

[Duncan Pucher]

June,

I found the container control and set to Master/Child Links and it worked great!

Thank you,