• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 270
  • Last Modified:

Access 2010 Web db: syntax for referring to forms/subforms

After mastering and using subform navigation for years in the Access client, along comes the web database and a similar, but not identical, way of referring to subforms.

I have a main form named "Navigation Form" with 4 tabs: MS Management, MS Management (Table View), Summary Management, and Search Form. The first three tabs each display an ordinary form. The Search Form on the fourth tab contains a Combo Box and a subform named Search Subform.

I am trying to figure out exactly how to refer to a control "ParentID" on the Search Subform in a macro that runs on the AfterUpdate of the Combo Box on Search Subform's parent, Search Form.  I have tried every permutation of forms I can think of, based on examples from all over the web, and they all return the error "..does not contain the Automation Object..." or "...must use a valid Path...".

I understand the meaning of these errors, but so far I have not stumbled onto the correct Path specification. Can anybody set me straight using the form names I included above?
0
dgmoore1
Asked:
dgmoore1
  • 2
1 Solution
 
rawilkenCommented:
have you tried...

[Forms]![Navigation Form]![SearchForm]![Forms]![ParentID]
0
 
dgmoore1Author Commented:
I found a simpler way - I was using the combo box to filter the records shown in the subform. I moved the combo box from the main form to the subform itself and it works correctly - doing it this way makes it unnecessary to specify Path to Subform Control.
0
 
dgmoore1Author Commented:
Found a better approach than I initially tried.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now