Updating a Sub form

[mikej]

I recently had to upgrade to ms 2007 and one of by sub forms no longer refreshes. The database needs to stay in ms 2000 format.

When I press a button from the main form a script is run generating a query. I am trying to apply this query to a subform and have tried various permutations and combinations of requery, refresh and set focus. e.g.

Forms![main]![sub].Form.RecordSource = "Select * from [query]"

Forms![main]![sub].SetFocus
Forms![main]![sub].Form.Requery
Forms![main]![sub].Form.Refresh
Forms![main].Form.Requery
Forms![main].Form.Refresh

Me.SetFocus
Me.Requery
Me.Refresh

Previously

Me.Requery
Me.Refresh

worked fine.

If I open the query, I can see the data ready for the subform If I close and reopen the form, I see the correct data.

I would really appreciated some help,

Mike