How to goto a specific record in a recordset displayed on a subform in another subfrom on a mainform

[oohzzur]

Good day All,

Can anyone help in resolving this challenge.



I am working with MS Access to write a program to assist students prepare for an exam. I want students to be able to go back and review questions that have not been answered which are displaced on a pop form at the students request. I want the student to be able to select a specific question on the pop up form and that question should be made the current record that is displayed in the subform inside another subform on the mainform. The challenge is that when I click on the question number on the pop form, I dont get any response. I tried to set focus to the sub sub form and then call the subform using docmd.gotorecord but I keep getting various errors.

Below is sample code block in a command button click event that when clicked should automatically displayed question 3 in the recordset.

sub command3_click()
forms!formmain!child52!child65.setfocus
docmd.gotorecord acdataform, "formmain!child52!child65", acgoto, 3

end sub.

my main form is formmain
the first subform is child52
the second subform is child65.

ALthough not indicated in the code, the records are displayed on a form named form4 in the child65 subform container.

Any assistance will be greatly appreciated.

oohzzur

[aytee111]

Link the subforms to the main form using master and child link properties. Then set the link field on the main form when they select the question and requery.

[June7]

Could definitely use more meaningful names.