Navigating records on subform

[gmazza via AccessMonster.com]

Hey there,
I have a form based on a table, and a subform based on the same table.
Is there anyway that when I move to the next record in my subform that my
main form can move to the next record as well?
Thanks!

 

[Klatuu]

Seems a stange thing to do, but to do it, you need to unlink your form and
subform.
Use the current event of the main form to sync up the subform with the main
form. And use the current event of the sub form to sync the main form.

 

[gmazza via AccessMonster.com]

Thanks for your reply Klatuu, I was only trying this as my other efforts to
achieve my goal are not working. Maybe you can help.
I have 3 forms.
1st form I add CriteriaValues to, so each record in the table has a
CriteriaValue.
TableName:Criteria - CriteriaId, ClinicalTrialId, CriteriaValue

2nd form I have a combo box of all CriteriaValues from the 1st form, and
based on the CriteriaValue I pick, I can add any number of
CriteriaOptionValue's for the repsective CriteriaValue, and those
CriteriaOptionValue's get stored in a table.
TableName:CriteriaOption - CriteriaOptionId, ClinicalTrialId, CriteriaId,
CriteriaOptionValue

For the 3rd form I need to display all the CriteriaValue's on the form that I
have in the table.
Right beside each CriteriaValue, I need a combo box with the
CriteriaOptionValue's I added in the 2nd form.
Once I choose the CriteriaOptionValue's for each CriteriaValue, I need that
information saved in another table.
TableNameatientData - PatientId, ClinicalTrialId, CriteriaId,
CriteriaOptionId

The 1st and 2nd form work fine, I am having problems getting the 3rd form
working.
I can't seem to display all the CriteriaValue's or the CriteriaOptions for
the respective CriteriaValue.
I assume I need a subform to display all this info, but I don't know what
Child and Master fields I need to be linking or anything.
I also could be needing more or different fields in my PatientData table, not
sure.

Do you have any suggestions?
Thanks!

 

[Klatuu]

It is a bit confusing, but since both subform controls are on the same form,
linking fields in the last subform may not work if the records to be selected
depend on values in the main form and the first subform. For this, you will
need to filter the subform's recordset on the values in the main form and the
first subform. It may also be necesssary to requery the last subform's
recordset in the subform's form current event.