I'm attempting to utilize a sql request control on my form. My connection to the sql server tests out fine. When I type in in the test query it will even test out fine. However, as soon as I close the test and run, nothing will show up in the control. When I go back into the run now and run a test query, I see the following error "Incorrect syntax near ' '. My sql query is pretty simple. Here is my query
SELECT TOP 1000 [PositionTitle]
FROM [Reporting].[dbo].[vwPositionTitle]
Here are my screenshots of what I'm seeing
