Hi,

I have a tabular form which displays the results of a saved query. Included on the form are controls to refine the displayed records by modifying the .SQL property of the underlying query. My problem is that I can not work out how to make the form display the new results - the the query changes, but the results displayed on the form do not. What method will achieve this without having to close and reopen the form?

Thanks,

Drew

After your code to modify the SQL statement, use a line like this for the form:

'==========
Me.Requery
'==========

  You could put this on the SQL modifier control's After Update event. You may have to use the absolute statement like this:

'=====
Forms!frmYourFormName.Requery
'=====

HTH



mmcdonal

Thanks for the input. I have tried using the requery command, but to no avail. The only way I have been able to do it is this:

Me.RecordSource = "qryLog"
'then code to build SQL string
CurrentDb.QueryDefs("qryLog").SQL = strSQL
Me.RecordSource = "qryLog"

I can't explain why, but it works!