I have been using MS Access ADP front end to an SQL Server 2012 database in several applications using hundreds of forms and reports over nearly ten years. However, in almost all cases I set the datasource at design time or by using vba dependent on user selection/events.
I have almost never...
