Paul,I did as suggested. I created a new form, with a data connection a drop down list bound to it. It'll let me save the form as dynamic, but when I preview it I still get only the first row of my tableThis is the query I use: select stateprovname from dbo.tblProvStates where country='CA'What am I ...