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

06-19-2011, 03:47 AM	#1
DBinPhilly VBAX Regular Joined: Jun 2008 Posts: 95 Kb Entries: 0 Articles: 0	link subform in an .adp file 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
Local Time: 01:35 PM Local Date: 05-20-2013