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.
Edited by: MattP on Wed Jan 25 9:06:17 EST 2006.