PDA

View Full Version : link subform in an .adp file



DBinPhilly
06-18-2011, 09:47 AM
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?

DBinPhilly
06-18-2011, 01:42 PM
Just a quick note: I tried using the main background table as the source of the subform while using calculated controls with domain functions to list the fields I wanted to list that were not members of the background table.

I haven't used domain functions in 15 years and I suppose I don't know what I'm dong, or they just aren't used in an .ADP file. I noticed there is no help to create the function like there is in an .mdb file.