requery and filters?

[branston]

Hi,

Should be a quick question... If you open a form via vba with a where condition and then re-query... eg:
DoCmd.OpenForm strFile, , , strCriteria
DoCmd.Requery

would the requery affect the where condition (i.e. remove it)?

I dont think it should, but thought it was worth a check!!

Thanks!

 

[ajetrumpet]

never tried it, but my guess would be NO. but...one thing i have done is manally filter a form with a dropdown box, and then requery it using a button, and that totally removes the filter and brings me back to the first record in the form, so you may want to watch out for that. use the trial and error method, and you wouldn't have to ask....