Updating rerport after filtering query?

[Coltom]

Just coming to Access from FMPro so familiar with relational DBs but not al la Access.

Problem :

- Have query 'customers_view' based on table 'customer'
- create report 'labels' using 'customers_view' as Record Source
- Labels report works/prints AOK
- But, if I filter query 'customers_view' to generate subset of records & then open labels the report still shows the previous iteration of query 'customers_view'

What do I need to do to ensure the labels report opens to show the new, saved filtered set of records in query 'customers_view'?

I view and filter the query 'customers_view' as a Datasheet so can't use a button. Can I use an event on On Open to refresh the report to show just the new records? I can get this to work if I open labels in Design View, choose a different 'customer' query record source and then immediately change back to the required query 'customers_view' record source. Can I code this somehow? Why doesn't ['customers_view 'query<->labels report] just refresh if I click the Refresh All button?

 

[NauticalGent]

Have you considered making the customer_view query a parameter query? It would essentially do what you want without having to use multiple querys.

 

[Coltom]

Have you considered making the customer_view query a parameter query? It would essentially do what you want without having to use multiple querys.

I'll have at that, thanks. Coming from FMPro though I 'see' a relationship between the report (Labels) and the newly filtered query based on the new filtering criteria. In FMPro, after perhaps a relationship 'refresh', the report would then reflect the new subset of records. The fact that when I simply swap out of then immediately choose the correct record source suggests that's what's happening here (unless it's not a relationship in that sense)

Anyway thanks.

 

[JHB]

Show the SQL-string for the query the report is based on.