Subform will not requery

[ecampos]

I am trying to requery a subform from a command button on a main form. The two forms are not linked. The subform data source is a SQL query I am updating manually. After making the query update (which works correctly) - I have tried every combination of requery/refresh commands I can think of to make the subform display the new data.

From the Parent form:
Me!Subform.Form.Requery


Me.Subform.Form.Requery
Me.Subform.Requery

I even tried putting a command button on the subform to execute Me.Requery

None of these work. I can open the underlying SQL query and see that it has changed. But the subform will just not display the new data. It will refresh and display the correct data only if I close and reopen the form. Subform is a continuous form if that matters.

Any idea what I could be missing?

Thanks

[Welshgasman]

Is Subform actually the subformcontrol name?

[ecampos]

In my program I am using the actual name of the subform control

[moke123]

The subform data source is a SQL query I am updating manually.

How are you doing this and how are you updating the record source of the subform?

[ecampos]

So I ended up getting this to work.

Me.Subform.Form.RecordSource = "QueryName"

That forces the subform to requery and display the new data. So my problem is fixed. But I would still like to know why the Form.Requery command does not work from either the parent form or the child form - if anyone has any ideas.

[ecampos]

How are you doing this and how are you updating the record source of the subform?

I am setting the query definition like this:

Public Sub SetQuery(query_name As String, query_string As String)
    Application.CurrentDb.QueryDefs(query_name).SQL = query_string
End Sub

I was not otherwise changing or updating the record source of the subform. It's just set in the properties.

[moke123]

But I would still like to know why the Form.Requery command does not work from either the parent form or the child form - if anyone has any ideas.

The form retains the original recordsource until it is changed would be my guess.