Subform Requery Problem

[walbr02]

I have two very similar search forms that show the results in a subform. I have one that works fine, but the other one will not requery. It is not necessary for the form to be linked to the subform, but I think that that has something to do with the problem. Here is the code for both

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


If there is a better way to do this, any input would be greatly appreciated!
Thanks,
Brian

 

[kraxmo]

Me!findTG30sub.Form.RecordSource = strSQL Jim Kraxberger
Developing Access solutions since 1995

 

[RickSpr]

Is that first line supposed to be changing the SQL property of the subform's record source? You sure can't do it that way. You can't change the properties of a QueryDef once it's been added to the database, you can only change them when you're creating one in code.

I suspect the Requery is working fine, but that you only think you're modifying its record source.

Since you already have an SQL statement built, you can just assign it to the subform's RecordSource property:
Me.findTG30sub.Form.RecordSource = strSQL
You don't even need the Requery if you do that, because changing a form's RecordSource automatically requeries.

(Note: A form's RecordSource property can be the name of a table, the name of a query, or an SQL SELECT statement.) Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein