Change recordset, change query SQL, works...try again and requery...doesn't

P

Paolo

Hi all,

I have a bound form by which the user can change recordset. Before the
recordset is changed to another query though, I change the querydef SQL
for the query using DAO. So far, so good. First time it works. If
the user decides to stay on this recordset change the querydef SQL of
this query and requery there is no requerying. The form stays stuck on
the previous recordsetWhen I open up the query in datasheet mode,
though, I see the latest recordset. What is going on?

Thanks,

Paolo

P.S. I've used both Me.requery and Me.refresh to no avail

[email protected], eliminating the NOSPAM
 
Top