Requery not working in Access2000

[chthomas]

When i converted an Access97 db to 2000db, a macro which i created to requery records in a subform datasheet is not working. Am getting the error message "you can't use apply filter action on this window". The subform datasheet gets its value as a result of filtering. Then i had given "requery" macro in the "After Update" event of the form. The same db is working perfectly in Access97. Requery is important since its on the network and many users use it simultaneously. Is this a known problem or are there any solutions?

 

[Hayley Baxter]

I've had problems in the past with a report when the database was converted from access 2000 to access 97. The report worked fine in 2000 but would not perform the counts I had set for the report in access 97. I did not find an explanation for this, however I kept trying to convert and eventually the report decided it was going to work. Very strange behaviour!

Hay