Master Form with same sub-form twice?

[tyallred]

Hello,

In Access 2003, I am trying to create a work-log which is a
(1) Main Form with some combo boxes and such for filtering purposes

(2) Imbedded Queried Form using values in #1 in DataSheet view
(3) Imbedded Form of of full Record (same as #2) in FormView

The purpose of this desired layout is so that a user can sort and prioritize their to-do's highlights and select which task to work on (and fill out the form of) next.

What I would like is for a way to UPON CLICK event of a #2 Row, update the #3 active Record.

Attached is a picture of the form layout. Again, it's one basic form, with two non-tied subforms (from the same table) also showing.

I have an ID hidden in #2 which I can see as value.id when I do the click event, but I cannot figure how to send the "goto" ID record or whatever to a the form (#3)

Many thanks for your time,
Tyler

 

[Pat Hartman]

In the RecordSource query for the single-record subform, reference the ID value in the multi-record subform.
Where SomeID = Forms!frmMain!sfrmMulti.Form!SomeID

Then in the Current event of the multi-record subform, requery the single-record subform.
Forms!frmMain!sfrmSingle.Form.Requery

 

[tyallred]

Thanks Pat, this approach worked very well!