Solved Problem with Form and subform (1 Viewer)

[maabadi]

Hi.
1. When I click on button at first form, it show inputbox that I should input on it (Step 4) . Why?
2. Then When I Press enter open second form Show filtered mainform but it doesn't show filtered subform. what is wrong with it? (Step 5)
3. I want to create report from subform when click button with all information on it. (Step 6)

 

[Pat Hartman]

1. If the prompt is unintended, it is caused because Access doesn't recognize a reference in a query and so it assumes you want to prompt for the value. Verify that all names in the query are actually present in the referenced table/query and are spelled correctly. This sounds familiar. Is this part of another of your threads?
2. Check the master/child links. The RecordSource for the subform should NOT include a join to the parent table. Also, if the subform does not allow additions and the parent record has no child records, the subform will be completely blank, without even labels.
3. Create the report. In the button on the subform, use the OpenReport method and use the where argument to filter the data.

 

[Mike Krailo]

The master/child links are wrong in the subform. You have:

Should be:

 

[maabadi]

Thanks @Pat Hartman and @Mike Krailo . I solved first part with your suggestions. but still subform doesn't show CenterID and Fields Name.
Please if it's possible check my file. thanks.

 

[arnelgp]

you do not need WellNo and FieldName fields on WellFixingT table.
i make the the Textboxes on the subform Unbound.
i added timer to the main form to set the values of these textboxes on the subform.
you can't set them directly (ie: Forms!CenterandFixingF!Centerid) since the subform Loads first before the main form.

 

[maabadi]

Thanks again @arnelgp .
You are my god at Microsoft access.