I'm working on a Windows application that is used for tracking document review and audit information for my company. The back end is a SQL server database and most of the user tasks are basic CRUD operations on the data that resides in SQL server. Most of the controls (listboxes, comboboxes, grids, etc.) are populated using simple SELECT statements from SQL Server. It's used entirely in-house and I have complete control over the application and the SQL Server. The end users only have access to the SQL data through the application.
What is the best practice for storing these control sources? Do the belong in the control's recordsource property when I design the form? (that's the simplest) Should I store them in a table in SQL server and load them into the controls when the form is loaded? (That's the most flexible because I can change the string with out redeploying the application) Is there something else?