Jimmy
Not nearly enough information to go on ...
What (specifically) does your "requery macro" do?
Does the redesigned query work properly as a stand-alone query?
How do you "add it to your form"?
"doesn't work" doesn't tell us much ... do you mean your PC erupts in
flames?<g>
.... any thoughts ... ? (Whoa, left yourself wide open THERE! Not a safe
opening line in this kind of 'group!)
Good luck
Regards
Jeff Boyce
Microsoft Access MVP
--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.
Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.
You can thank the FTC of the USA for making this disclaimer
possible/necessary.