Change a subform's recordsource from another subform in Access

Posted by Dkellygb on Stack Overflow See other posts from Stack Overflow or by Dkellygb
Published on 2010-03-20T16:46:07Z Indexed on 2010/03/20 16:51 UTC
Read the original article Hit count: 398

Filed under:

access

|

subforms

I am using MS Access 2003 and I have a form with two subforms (subform1 and subform2) which are not nested. They both display tabular data on them so they cannot be nested. I would like to change the recordsource on subform2 based on a value in the current record on subform1.

I have tried to put the code in the oncurrent event of subform1 but I cannot seem to refer to the recordsource in subform2 from subform1. From subform1 I have tried me.parent!subform2.form.recordsource but I get a runtime error ‘2455’ You have entered an expression that has an invalid reference to the property form/report.

Any ideas?

© Stack Overflow or respective owner

Related posts about access

Postgres user drop

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to drop a user: drop user testUser; I want to force this to work in a simple manner (Not a million calls)... How can I do this easily? I get this output: ERROR: role "testUser" cannot be dropped because some objects depend on it DETAIL: access to table main.tap_db_version access… >>> More
Postgres user/role drop

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to drop a user: drop user testUser; I want to force this to work in a simple manner (Not a million calls)... How can I do this easily? I get this output: ERROR: role "testUser" cannot be dropped because some objects depend on it DETAIL: access to table main.tap_db_version access… >>> More
ASA hairpining: I basicaly want to allow 2 spokes to be able to communicate with each other.

as seen on Server Fault - Search for 'Server Fault'
ASA Spoke to Spoke Communication I have been looking at spke to spoke comms or "hairpining" for months and have posted on numerouse forums but to no avail. I have a Hub and spoke network where the HUB is an ASA Firewall version 8.2 * I basicaly want to allow 2 spokes to be able to communicate with… >>> More
.NET Access automation with Access 2007 Runtime

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm having trouble deploying .NET application which uses Microsoft Access automation. I've installed the Access 2007 Runtime and Primary Interop Assemblies (PIAs) on the target machine: Access 2007 Runtime Office 2007 PIAs However, when I try to create the ApplicationClass: Application access… >>> More
Cisco 800 series won't forward port

as seen on Server Fault - Search for 'Server Fault'
Hello ServerFault, I am trying to forward port 444 from my cisco router to my Web Server (192.168.0.2). As far as I can tell, my port forwarding is configured correctly, yet no traffic will pass through on port 444. Here is my config: ! version 12.3 service config no service pad service tcp-keepalives-in service… >>> More

Related posts about subforms

subforms in Zend

as seen on Stack Overflow - Search for 'Stack Overflow'
How subforms created in zend? Please explain with an example. >>> More
Winforms MVP with Castle Windsor - DI for subforms?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm building a winforms app utilizing passive-view MVP and Castle Windsor as an IoC container. I'm still a little new to dependency injection and MVP, so I'm looking for some clarity... I have a main form which contains a number of user controls, and also will bring up other dialogs (ex. Login,… >>> More
Zend_Form using subforms getValues() problem

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I am building a form in Zend Framework 1.9 using subforms as well as Zend_JQuery being enabled on those forms. The form itself is fine and all the error checking etc is working as normal. But the issue I am having is that when I'm trying to retrieve the values in my controller, I'm receiving… >>> More
"Subforms" associated with tree view in VB

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using VB Express 2008 to demonstrate my ideas for an improved UI for an existing product for my colleagues at work. The current UI has a certain page with ten tabs, allowing the user to define up to ten "things". The available choices for each of the ten "things" are all the same. On each of… >>> More
Change a subform's recordsource from another subform in Access

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using MS Access 2003 and I have a form with two subforms (subform1 and subform2) which are not nested. They both display tabular data on them so they cannot be nested. I would like to change the recordsource on subform2 based on a value in the current record on subform1. I have tried to put… >>> More