Share via

MS Access - Refresh subreport on a form

Anonymous
2022-11-02T22:43:44+00:00

Hello,

I have a subreport on a main form. When I use the record navigations on the main form the subreport data does not refresh/update unless I click the refresh button on the menu ribbon. I have linked my master and child fields.

I'd like to display the data in report format as the continuous form option doesn't present the data in the sub in the best format. Is there anything I can do to correct this issue?

Thanks

G

Microsoft 365 and Office | Access | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
2022-11-02T22:45:50+00:00

Does the subreport control have LinkMasterFields/LinkChildFields properties? Those can be used to automatically refresh the child data.

Was this answer helpful?

1 person found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-11-02T23:46:38+00:00

    I changed my report data source and this worked. Thanks!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-11-02T22:59:30+00:00

    Yes. The subreport has the Master Fields and Child Fields linked. The report feeds from a query.

    Thanks

    Was this answer helpful?

    0 comments