Form with subform with subform HELP!

[chungiemo]

Hi all, been a while I used Access and doing a small database to store each patients activity.

It was going to be in one form, patient fields then in a subform Track and next another subform ActionPoint. This really looks messy so I added a button so I could display table Track and then subform ActiionPoint in a separate form to make it clearer but I am not sure how to pass both all Track and Actionpoint records into a new form that matches the Hospital No.

Table: Patient
HospitalNo, Firstname, Lastname

Table: Track
TrackNo, EntryPoint, EntryDate, Comment, ActionPointNo, Hospital No

Table: ActionPoint
ActionPointNo, TrackNo, ActionPlanDate, Initials, ActionPlanned

I know that the Hospital No needs to be compared to the text Hospital No but really not sure how to do this.

Something like this:-
"[HospitalNo] = " & Me.txtHospitalID

Any help would be appreciated

Ive attached a file to show my example, frmPatient is the main form and shows subforms which am avoiding, if you click command button it goes to a new form which I want to pass the filter to.

Man chun

 

[MStef]

Hello Mofo!
Here it is, I think it is what you need, (attachment, zip).
Look at "frmTrack&Action" RECORD SOURCE property.
I suggest, the command button put in Form Footer.