I am populating a form using SELECT SQL against a table with a couple of lookup fields. When I apply a filter or a sort to the SQL and open the form I am asked to spply parameters for the lookup fields. Under what circumstances are parameters required, or, to put it another way, what am I doing wrong?

Thanka for the help

HiArt

Your Select SQL is structured incorrectly. You evidently have criteria in your SQL that is being interpreted as prompts. Prompts, as well as fields, are enclosed by square brackets.

Try figuring out what's wrong with your Select SQL by using the QBE frame.