PDA

View Full Version : link subform in an .adp file



DBinPhilly
06-19-2011, 03:47 AM
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