Solved Filter subform with same criteria as main form (1 Viewer)

[maabadi]

Hi. I have 3 tables (FieldT, WellT and WellFixingT). I related FieldT with WellT with FieldID and Then WellT With WellFixingT with WellID.
Then I created Forms based WellT and WellFixingT. When I Double-click on ID (WellID) at First Form, it open Second form (with Subform).
Problem is Mainform show Well Characteristics But Subform doesn't show. ( Mainform source is WellT, But Subform Source is WellFixingT)
I want to add Fixing Detail in Subform. What is Problem? (my form is persian)

 

[arnelgp]

i comment out the code on your Load/Current event.
You don't need to filter since, you already have a Master/Child Link Fields set.

 

[maabadi]

i comment out the code on your Load/Current event.
You don't need to filter since, you already have a Master/Child Link Fields set.

Thanks @arnelgp , but still subform doesn't show WellID, Field Name and WellNo? Why?

 

[arnelgp]

I don't think you need FieldName and WellNo field in your WellFixingT.
since they are already exists on table WellT and the FieldName in table FieldT.

i created a Query (see Record Source of the subform) to get the FieldName and WellNo field.
you need not save these 2 fields in WellFixingT.

 

[maabadi]

Thanks and sorry for late replying. this problem solved with your recommendations.
But I have one more problem. if it is need to post as new thread tell me to do it.
When I want to print that form (With Bottom Button) ( I want to see information from WellT and WellfixingT on Report). I see this error:

 

[arnelgp]

you upload again your db and i will have a look.
It seems it is an error on the Query/Record source of the report.

 

[maabadi]

This is my last modified DB

 

[arnelgp]

you check the changes in FixWellQ query.

 

[maabadi]

Special Thanks mate. this is really what I want.
You really saved me.