Robert,
Yes. If I change it to "Ask for Values" it completes the query successfully.
For Unique...I have just the Unique button enabled, nothing for "Ask for Values", nothing enabled for "Value is required to be entered to enable search", and the SQL statement reads "HOA_Name = ''
It was cycling before...now it doesn't search at all.
I'm mystified.