Full Version: Changing Data in Sub form, based on record in other subform
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
MattP
Title is confusing as the question :

Ok I have a main form "FRM_SUMMARYREVIEW", on this form I have two sub forms:

Sub form 1 - " FRM_OPENSUMMARY" at the top half of the main form &
Sub form 2 - "FRM_MAINDATA" at the bottom half of the main form

"FRM_OPENSUMMARY" is a form that lists all my open escalations, and is in a continuous form view, one of the fields is called "EscalationID", this is my unique record ID for each escalation.

In the past I could click on the "EscalationID" box in one of the records (in FRM_OPENSUMMARY) and it would open "FRM_MAINDATA" as a new form, with the details of that escalation.

What I would like is that as I cursor, or tab down the list of open Escalations I have in" FRM_OPENSUMMARY", the details in the form "FRM_MAINDATA", change accordingly to show the detail of that particular escalation.

I hope this makes sense, I got lost writing this !!??

Appreciate any help you can provide.

Regards

Mattp

Edited by: MattP on Wed Jan 25 9:06:17 EST 2006.
fkegley
Open the form in Design View, click on the subform subcontrol, be sure the Link Master Fields and Link Child Fields properties are set correctly.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.