Requerying data ina subform

[AndySuk]

Hi Folks

I have a query based on a table which gives a breakdown of sales by month, sale type and by cost centre (department).

I also have another query which summarises the sales by sale type and cost centre so that and is based on the first query.

the second query is a subform of the first. I tried the second query as an update query but couldn't figure out how to execute it in order to refresh the subform. I've also tried to requery the second query having recreated it as a select query but I'm not able to refresh the data.

The aim is to refresh the data in the subform as any of the underlying data is changed in the original form.

I'm ok with VBA and with macros so if anyone has any advise or ideas I'd appreciate it.

Many thanks

Andy

 

[KeithG]

Forms![Main Form]![Sub form name].Form.Requery

 

[AndySuk]

Doh!!

Many thanks Keith