link subform in an .adp file
I am converting a .mdb database to an MS Access project. I've made good progress, but I seem to be having trouble making subforms work.
The subforms I brought over from .mdb are not operating properly. I've created Views and/or Stored Procedures to mimic the MS Access queries that were behind the original subforms.
I've tried using the wizard to re-link a subform to a form, but the wizard does not give the option to choose linking criteria, even though those criteria exist in the properties tab. When I manually enter the criteria in the properties tab, nothing happens.
I've tried creating a SQL statement that loads when the subform loads. I've tried creating a filter in the subform properties.
I'm running out of options. Any idea what I am doing wrong?
NOTE: Using MS Access 2010 and SQL Server 2008 Developer's Edition