subform requery

[walbr02]

I have a search form with a couple of different criteria that has a subform that displays the results. I have had no problems using strSQL to change the query based on the user input, but I cannot get the subform to requery or refresh from the cmdButton_click
subroutine:

Dim strSQL As String

If Not BuildSQLString(strSQL) Then
MsgBox "There was a problem with your search"
Exit Sub
End If

CurrentDb.QueryDefs("qrySearchT&quot.SQL = strSQL
Me!findTG_3_0sub.Requery

The QueryDefs works, but the requery just won's work.
I've searched through the forum ad-nauseum for this, and have tried everything, but I still can't get this to work.

Any help would be greatly appreciated!!!
Thanks,
Brian

 

[vbajock]

I think I had a similiar problem. I think I just declared
a form object, assigned the subform to it, and then did a requery on the form object.
Dim someform as form

set someform=forms!myform!findTG_3_0sub

someform.Requery
You might have to play with a little bit but that's the general idea.

 

[walbr02]

thanks VBA jock,
I did something similar that seems to work: the main form did not need a record source, since it was input only, but I added the table that it was searching as a source, and then it recognized the requery. It seems to be working now.

Thanks for the reply!
Brian