records not showing on subform when doing EDIT

[osupratt]

i have a main form with several sub-forms. the end user does their data entry. if needed to edit any of the info after they have done their entry and have closed the form out..... they open this main form back up and all the info should appear on main form and all sub-forms. the record source when opening this form for edit is a query. i can run the query and all records show as expected; however, when opening the form sometimes a sub-form might not show it's records. i remove the master/child links and then records appear but ALL records appear out of the table for the sub-form. i am at a loss right now on why this is happening. just very odd to me that the records show when running query that is the record source for the form but when opening the form they are not present in the sub-form. is there some simple setting that i have wrong? a big duh right now. thanks for any help.

[June7]

What is the query SQL for the subform?

The form and subforms reflect parent/child relationships of tables?

Really need better understanding of data structure and form design. If you want to provide db for analysis, follow instructions at bottom of my post.

[osupratt]

thank you. after a day of troubleshooting this issue i posted this question in the forum. of course right after i posted this i continued with trying to figure things out and i think i have it. on the main form when doing the initial data entry i have about six master/child links that auto fill several text boxes of sub-form(s). i took out several of these links except for the main one or two and it is now working. i guess i can go back and figure out which one exactly was the cause and then get into it more but wanted just reply to this and say that it can be closed and thanks June7 for you initial response!